Excel - Chart (scatter plot): values on X-axis.

Asked By Jim on 23-Jun-08 03:23 PM
I have a chart (scatter) in Excel 2007 with dates on the x-axis and some
value in the y-axis. The source for the dates is formatted as Monday
23-Jun-2008. In the graph what appears is numbers like $39,508.0. Otherwise
the graph looks as expected. I know I did something wrong when I made the
scatter plot, but I don't manage to repair it.

I'll appreciate any suggestions.


D8.Consultor replied on 26-Jun-08 01:40 AM
In the graph plot select the axis (left click, be sure only that axis
is selected) that displays the wrong format, after aving selected it
right click on it and select any format you would  like too.