LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Bob
 
Posts: n/a
Default graphing data of different frequencies

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 08:09 AM
Graphing only data that meets a condition Heidi Charts and Charting in Excel 2 January 19th 06 08:32 PM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
Importing Data Jillian Excel Worksheet Functions 9 December 23rd 05 12:45 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"