|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 1st, 2006, 05:55 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
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! 
|
|
#2
March 1st, 2006, 06:29 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
date axis
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" wrote in message ... 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!
|
|
#3
March 1st, 2006, 06:50 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
date axis
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" wrote in message ... 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!
|
|
#4
March 1st, 2006, 06:56 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
date axis
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" wrote in message ... 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" wrote in message ... 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!
|
|
#5
March 1st, 2006, 06:57 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
date axis
"Mona" wrote in message
... 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
|
|
#6
March 1st, 2006, 07:07 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
date axis
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" wrote in message ... 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!
|
|
#7
March 1st, 2006, 07:12 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
date axis
thank you, xy scatter works!!
"David Biddulph" wrote: "Mona" wrote in message ... 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
|
|
#8
March 1st, 2006, 11:21 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
date axis
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" wrote in message ... thank you, xy scatter works!! "David Biddulph" wrote: "Mona" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Date X axis Affect Bar Width in a Bar Chart | Toby | Charts and Charting | 1 | November 9th, 2005 08:58 PM |
| Outlook today should show tasks based on Start Date, not due date | Rose | General Discussion | 10 | October 9th, 2005 03:14 AM |
| Date Range and Average F/X Rate | David | General Discussion | 0 | June 23rd, 2005 02:26 PM |
| QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |
| Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
Linear Mode
