Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Graph is not updating y axis value properly

Copper Contributor

table.PNG


graph.PNG

I have an issue where the data I am trying to plot on my table is not showing up correctly in the graph. As shown in the screen shot, I am plotting the concentration vs days in operation. There are other tables associated with this graph that are not visible.

It seems that the latest data point from 12/23/2023 is not plotting the y axis properly. The x axis is correct (295) but the y axis is showing on the graph as zero but it should be at 11. All other data points are correct on this graph. I have tried to trouble shoot myself and make sure that the value/text format is the same as others. Also, the numbers shown on the table are retrieved using a xlookup formula that is referring to a different sheet. I have also made sure that sheet has the correct value/text formats. I am mentioning this because I noticed that when I removed the formula and type "11" then the graph updated correctly. However, ideally I want to keep the formula in the cells. I am unsure how to fix this issue.

1 Reply

@water162490 I suspect that the value returned by the VLOOKUP is a text. Then you can't resolve that by formatting the cell with the VLOOKUP as a number. It will still contain a text. Look into the the format of the "11" in the source data and make sure it is a number.