G
Guest
I periodically make a x,y scatter chart using dates for x
and a number for y, like this:
x y
8/12 213
8/13 254
8/14 198
etc.
Previously, when I would use the mouse to point at a
point on the chart, Excel would display the date and the
number (e.g. 8/13,254). Now, with my most recent chart,
Excel displays a sequential number instead of the date
(e.g. 2,254). Why has it changed? And where in Excel
can you specify how the x value is to be displayed?
and a number for y, like this:
x y
8/12 213
8/13 254
8/14 198
etc.
Previously, when I would use the mouse to point at a
point on the chart, Excel would display the date and the
number (e.g. 8/13,254). Now, with my most recent chart,
Excel displays a sequential number instead of the date
(e.g. 2,254). Why has it changed? And where in Excel
can you specify how the x value is to be displayed?