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.
