Sounds like you don't have numerical data in the range of dates.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Sean" wrote in message
ups.com...
On Jun 7, 1:02 am, "Jon Peltier"
wrote:
Chart menu Source Data Series tab. Click in the box where it says
Category (X) Axis Labels, and select the range of dates with the mouse.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

"Sean" wrote in message

ups.com...

I have data that varies on a daily basis. There are three series of
data - sales, productivity and refunds. For every series there's
multiple data for each day. For example, on Monday 7th June there are
three sales figures 10, 20, 30; three productivity figures 10%, 20%
and 30% and three refunds worth $5, $10, $15. The data is entered on a
daily basis.

I want to create a chart that shows this detail on a daily basis i.e.
on the X-Axis it should list date and for each date it should plot the
values for those series. I have already created a chart with the three
series however I have not been able to get the dates on the x-axis.

Please help. Any help or pointers in this matter would be greatly
appreciated.

Cheers

Sean

I have tried that. The problem is that the scale (x-axis) starts from
1/1/1900 and goes on till year 2036. This is pointless because I am
looking at a much shorter time scale. I have not been able to figure
out how to fix this. Also, I think I want x-axis as category because
there are a variable number of y-values for a category. I have not
been able to find out any articles on scaling the time line.

Any help would be appreciated. Thanks in advance.

Cheers

Sean