Hi All!
I have a dataset where the x axis represent weekly dates and the y axis are random values between -1 and 1.
In the x and y axis I have some N/A() errors used to make the graph ignore these data points and start plotting at the first value in the x axis.
However, when I hover the mouse along the area graph, it shows a date that doesn't correspond to the x series.
I also tested with other types of graphs and this problem shows only on area graphs.
I attached an excel file containing an example of the problem.
Do you guys know if this is a technical bug on Excel and if there's alternatives to fix it?
Thanks in advance!
Bookmarks