Windows Software

MS Excel 2003 Chart help

•

Join Date: Nov 2007

Posts: 19

Reputation: momtworugrats is an unknown quantity at this point

Solved Threads: 0

momtworugrats momtworugrats is offline

Offline

Newbie Poster

MS Excel 2003 Chart help

Sep 18th, 2008

When making a chart, is there a way to change the x values? I want them to be listed as dates instead of just 1, 2, 3...

•

Join Date: Mar 2007

Posts: 306

Reputation: timothybard is an unknown quantity at this point

Solved Threads: 26

timothybard timothybard is offline

Offline

Posting Whiz

Re: MS Excel 2003 Chart help

Sep 18th, 2008

Yes, you can have the x values as dates.

1) List your dates in a column.
2) List your y values in the column to the right of your dates
3) Highlight the Dates and y values and click on the Chart wizard icon.
4) On step 3 of 4 of the chart wizard, click on the Axes tab.
5) For the Category (X) axis, select Time-Scale.

This will make Excel treat the dates as vales and not categories.

You can read more about this here:
http://peltiertech.com/Excel/ChartsH...ValueAxis.html