chart help

  • Thread starter Thread starter jan
  • Start date Start date
J

jan

I am trying to create a chart which lists dates on the Y
axis and numbers on the X axis. I can't seem to figure
out how to get the dates on the Y axis. Every time I use
the Chart Wizard, it puts the dates on the X axis....If I
do manage to get the dates on the Y axis, I can't define
the numbers along the X axis..

Anyone know how to do this?

Thanks,
Jan
 
The easiest way to do this would be to list the numbers in column A, and
the years in column B.

Select a cell in the list, and click the Chart Wizard button
Select the XY (Scatter) chart type, and the subtype with points and lines

After the chart is created, double-click the Y axis.
On the Scale tab, enter 1 as the major unit.

Jon Peltier has an article on chart types that may help:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190
 
Back
Top