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

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
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.
 
Back
Top