Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
I would like to make a line chart of time series data with different frequencies. For instance, I have some data that occurs monthly and some data that is only annual. How can I put them both on the same chart with the same X (date) axis. I want line and/or bar charts, not scatter plots. Here is a sample: Annual Data: 12/31/2004 70 12/31/2005 80 12/31/2006 90 Monthly Data: 1/31/2004 68 2/29/2004 95 3/31/2004 15 4/30/2004 37 5/31/2004 89 6/30/2004 73 7/31/2004 13 8/31/2004 55 9/30/2004 5 10/31/2004 86 11/30/2004 1 12/31/2004 28 1/31/2005 80 2/28/2005 85 3/31/2005 7 4/30/2005 73 5/31/2005 29 6/30/2005 57 7/31/2005 29 8/31/2005 52 9/30/2005 83 10/31/2005 48 11/30/2005 83 12/31/2005 50 1/31/2006 47 2/28/2006 23 3/31/2006 17 4/30/2006 5 Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Graphing only data that meets a condition | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel |