Let's see if you can solve this.
 

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

Date on the x-axis
 

On Tue, 5 Jun 2007, in microsoft.public.excel.charting,
Sean said:
I want to create a chart that shows 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.

Have you left the cell at the top of the x-axis range, the one where the
labels go on the other ranges, blank? If you use the Microsoft wizards,
they must have a blank cell in the top left hand corner, or they won't
recognise the x-axis.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Date on the x-axis
 

On Jun 6, 5:11 pm, Del Cotter wrote:
On Tue, 5 Jun 2007, in microsoft.public.excel.charting,Sean<sukant.sa...@ gmail.com said:

I want to create a chart that shows 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.

Have you left the cell at the top of the x-axis range, the one where the
labels go on the other ranges, blank? If you use the Microsoft wizards,
they must have a blank cell in the top left hand corner, or they won't
recognise the x-axis.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Sorry Del,

I wasn't able to understand you in that post. I am a bit of a noob in
excel. Anyhow, here's the link to the file :

http://www.megaupload.com/?d=1EAUBBTH

Sheet1 is meaningless, Sheet 2 has the data and Sheet 3 has the
graphs.

Thanks.

Cheers

Sean

Let's see if you can solve this.
 

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

Let's see if you can solve this.
 

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

Let's see if you can solve this.
 

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