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

J

Jim

Hi,
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.

Jim
 
D

D8.Consultor

Hi,
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.

Jim
Click to expand...

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'd like too.
 
Top