|  | Chart (scatter plot): values on X-axis. | | |
| | | Jim |  |
|  Posted: Mon Jun 23, 2008 5:23 pm Post subject: Chart (scatter plot): values on X-axis. |  |
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 |
| |
| | | D8.Consultor | |
| | Posted: Mon Jun 23, 2008 8:46 pm Post subject: Re: Chart (scatter plot): values on X-axis. | |
On Jun 23, 3:23 pm, "Jim" <jim6...@nospamTRTnet.nl> wrote:
| Quote: | 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
|
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. |
| |
|
|
