How do I get years to show on x-axis?

C

Carol

I am plotting two time series lines on a line graph (they show up as a single
line, solid for the actuals and dotted for the forecast):

Yr. TS-1(actuals ) TS-2 (forecast)
----- ---------------- ------------------
2001 value1
2002 value 2
2003 value 3 value 3
2004 value 4
2005 value 5

When I plot this, I get consecutive numbers (i.e. 1, 2, 3, 4, 5) instead of
years as labels on the x-axis. How do I fix this? THANKS!
 
J

Jon Peltier

Clear the top left cell, then make the chart. This helps Excel decide what
to use for series names and category values.

- Jon
 
C

Carol

OMG that was so simple, thanks for this and your earlier help on my Excel
chart issues. Kudos.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top