Thread: date axis

I am using a line chart with 2 + series using dates on the x axis. For
example:

01/05/2005 200
01/06/2005 300
01/07/2005 400
01/08/2005 500
01/09/2005 600
01/10/2005 700

I want to add an additional series from a separate worksheet that has
example data:

01/08/2005 1000
01/09/2005 2000

My question is how do I plot the second series so that the date plots
correctly. If I try to plot the second series it will plot using:

01/05/2005 1000
01/06/2005 2000

I was hoping to not add additional rows of dates. Thanks!

To add the 2nd series, select your chart. Chart menu should now be visible
on top menu

1. Goto Chart menu
2. Select Source Data
3. Select Series
4. Press Add Series choice
5. Enter series ranges

You should now have the 2nd series.




"Mona" <Mona@discussions.microsoft.com> wrote in message
news:F25C493A-B57F-46A3-A604-EA4B026CEDF3@microsoft.com...
>I am using a line chart with 2 + series using dates on the x axis. For
> example:
>
> 01/05/2005 200
> 01/06/2005 300
> 01/07/2005 400
> 01/08/2005 500
> 01/09/2005 600
> 01/10/2005 700
>
> I want to add an additional series from a separate worksheet that has
> example data:
>
> 01/08/2005 1000
> 01/09/2005 2000
>
> My question is how do I plot the second series so that the date plots
> correctly. If I try to plot the second series it will plot using:
>
> 01/05/2005 1000
> 01/06/2005 2000
>
> I was hoping to not add additional rows of dates. Thanks!

I might be missing something ??

When I do as you suggested the 2nd series plots as
01/05/2005 1000
01/06/2005 2000

Instead of

01/08/2005 1000
01/06/2005 2000

I want my graph to plot 01/01/2005 through 01/10/2005.

thanks!

"Kelly O'Day" wrote:

> To add the 2nd series, select your chart. Chart menu should now be visible
> on top menu
>
> 1. Goto Chart menu
> 2. Select Source Data
> 3. Select Series
> 4. Press Add Series choice
> 5. Enter series ranges
>
> You should now have the 2nd series.
>
>
>
>
> "Mona" <Mona@discussions.microsoft.com> wrote in message
> news:F25C493A-B57F-46A3-A604-EA4B026CEDF3@microsoft.com...
> >I am using a line chart with 2 + series using dates on the x axis. For
> > example:
> >
> > 01/05/2005 200
> > 01/06/2005 300
> > 01/07/2005 400
> > 01/08/2005 500
> > 01/09/2005 600
> > 01/10/2005 700
> >
> > I want to add an additional series from a separate worksheet that has
> > example data:
> >
> > 01/08/2005 1000
> > 01/09/2005 2000
> >
> > My question is how do I plot the second series so that the date plots
> > correctly. If I try to plot the second series it will plot using:
> >
> > 01/05/2005 1000
> > 01/06/2005 2000
> >
> > I was hoping to not add additional rows of dates. Thanks!
>
>
>

I suggest that you use an XY (Scatter chart). My previous post works well
with your data for an XY chart, it doesn't work with a line chart.


"Kelly O'Day" <dkod@comcast.net> wrote in message
news:%23Wkdh4VPGHA.916@TK2MSFTNGP10.phx.gbl...
> To add the 2nd series, select your chart. Chart menu should now be visible
> on top menu
>
> 1. Goto Chart menu
> 2. Select Source Data
> 3. Select Series
> 4. Press Add Series choice
> 5. Enter series ranges
>
> You should now have the 2nd series.
>
>
>
>
> "Mona" <Mona@discussions.microsoft.com> wrote in message
> news:F25C493A-B57F-46A3-A604-EA4B026CEDF3@microsoft.com...
>>I am using a line chart with 2 + series using dates on the x axis. For
>> example:
>>
>> 01/05/2005 200
>> 01/06/2005 300
>> 01/07/2005 400
>> 01/08/2005 500
>> 01/09/2005 600
>> 01/10/2005 700
>>
>> I want to add an additional series from a separate worksheet that has
>> example data:
>>
>> 01/08/2005 1000
>> 01/09/2005 2000
>>
>> My question is how do I plot the second series so that the date plots
>> correctly. If I try to plot the second series it will plot using:
>>
>> 01/05/2005 1000
>> 01/06/2005 2000
>>
>> I was hoping to not add additional rows of dates. Thanks!
>
>

"Mona" <Mona@discussions.microsoft.com> wrote in message
news:F25C493A-B57F-46A3-A604-EA4B026CEDF3@microsoft.com...
>I am using a line chart with 2 + series using dates on the x axis. For
> example:
>
> 01/05/2005 200
> 01/06/2005 300
> 01/07/2005 400
> 01/08/2005 500
> 01/09/2005 600
> 01/10/2005 700
>
> I want to add an additional series from a separate worksheet that has
> example data:
>
> 01/08/2005 1000
> 01/09/2005 2000
>
> My question is how do I plot the second series so that the date plots
> correctly. If I try to plot the second series it will plot using:
>
> 01/05/2005 1000
> 01/06/2005 2000
>
> I was hoping to not add additional rows of dates. Thanks!

You need to make sure that you are using an X-Y (scatter) graph, not a line
chart.
When you add each series of data, make sure that you include the dates as
your X axis values.
--
David Biddulph

I have a typo:
Instead of

01/08/2005 1000
01/09/2005 2000


"Mona" wrote:

> I might be missing something ??
>
> When I do as you suggested the 2nd series plots as
> 01/05/2005 1000
> 01/06/2005 2000
>
> Instead of
>
> 01/08/2005 1000
> 01/06/2005 2000
>
> I want my graph to plot 01/01/2005 through 01/10/2005.
>
> thanks!
>
> "Kelly O'Day" wrote:
>
> > To add the 2nd series, select your chart. Chart menu should now be visible
> > on top menu
> >
> > 1. Goto Chart menu
> > 2. Select Source Data
> > 3. Select Series
> > 4. Press Add Series choice
> > 5. Enter series ranges
> >
> > You should now have the 2nd series.
> >
> >
> >
> >
> > "Mona" <Mona@discussions.microsoft.com> wrote in message
> > news:F25C493A-B57F-46A3-A604-EA4B026CEDF3@microsoft.com...
> > >I am using a line chart with 2 + series using dates on the x axis. For
> > > example:
> > >
> > > 01/05/2005 200
> > > 01/06/2005 300
> > > 01/07/2005 400
> > > 01/08/2005 500
> > > 01/09/2005 600
> > > 01/10/2005 700
> > >
> > > I want to add an additional series from a separate worksheet that has
> > > example data:
> > >
> > > 01/08/2005 1000
> > > 01/09/2005 2000
> > >
> > > My question is how do I plot the second series so that the date plots
> > > correctly. If I try to plot the second series it will plot using:
> > >
> > > 01/05/2005 1000
> > > 01/06/2005 2000
> > >
> > > I was hoping to not add additional rows of dates. Thanks!
> >
> >
> >

thank you, xy scatter works!!

"David Biddulph" wrote:

> "Mona" <Mona@discussions.microsoft.com> wrote in message
> news:F25C493A-B57F-46A3-A604-EA4B026CEDF3@microsoft.com...
> >I am using a line chart with 2 + series using dates on the x axis. For
> > example:
> >
> > 01/05/2005 200
> > 01/06/2005 300
> > 01/07/2005 400
> > 01/08/2005 500
> > 01/09/2005 600
> > 01/10/2005 700
> >
> > I want to add an additional series from a separate worksheet that has
> > example data:
> >
> > 01/08/2005 1000
> > 01/09/2005 2000
> >
> > My question is how do I plot the second series so that the date plots
> > correctly. If I try to plot the second series it will plot using:
> >
> > 01/05/2005 1000
> > 01/06/2005 2000
> >
> > I was hoping to not add additional rows of dates. Thanks!
>
> You need to make sure that you are using an X-Y (scatter) graph, not a line
> chart.
> When you add each series of data, make sure that you include the dates as
> your X axis values.
> --
> David Biddulph
>
>
>

If you like the nice formatting options of the Line Chart's time axis, keep
the first series as a line chart. Make sure the axis is formatted with the
base unit in days. Add the second series, convert it from line to XY type
(Chart menu: Chart Type), then while ignoring the funky new secondary axes,
double click on the new series, and on the Axis tab, choose Secondary.

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

"Mona" <Mona@discussions.microsoft.com> wrote in message
news:3A36647B-4349-4DCE-923C-5F895C4E0FF7@microsoft.com...
> thank you, xy scatter works!!
>
> "David Biddulph" wrote:
>
>> "Mona" <Mona@discussions.microsoft.com> wrote in message
>> news:F25C493A-B57F-46A3-A604-EA4B026CEDF3@microsoft.com...
>> >I am using a line chart with 2 + series using dates on the x axis. For
>> > example:
>> >
>> > 01/05/2005 200
>> > 01/06/2005 300
>> > 01/07/2005 400
>> > 01/08/2005 500
>> > 01/09/2005 600
>> > 01/10/2005 700
>> >
>> > I want to add an additional series from a separate worksheet that has
>> > example data:
>> >
>> > 01/08/2005 1000
>> > 01/09/2005 2000
>> >
>> > My question is how do I plot the second series so that the date plots
>> > correctly. If I try to plot the second series it will plot using:
>> >
>> > 01/05/2005 1000
>> > 01/06/2005 2000
>> >
>> > I was hoping to not add additional rows of dates. Thanks!
>>
>> You need to make sure that you are using an X-Y (scatter) graph, not a
>> line
>> chart.
>> When you add each series of data, make sure that you include the dates as
>> your X axis values.
>> --
>> David Biddulph
>>
>>
>>