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

Create a line chart using the first series. Use Days as the base unit of the
axis. Add subsequent series as XY series, and make sure they are on the
primary axis. They will use the same axis, without using the same X values
as the first series.

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

"Bob" wrote in message
ups.com...
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

Bob:

Your question says "I want line and/or bar charts, not scatter plots."

Just to make sure that the obvious is clear, you can make great looking line
chart with an XY Scatter Chart. XY Scatter Charts let you plot the points,
the points an line or just the line.

To me, line charts are actually a subset of XY charts where the X axis is a
categorical variable. Excel plots categorical variable data with similar
techniques as used with XY charts, only real difference is X axis labeling
and placement of tick marks.

Since many users are confused about Line Charts versus XY Scatter plots, any
feedback on your concerns about XY - Scatterplots would be helpful.

...Kelly




"Jon Peltier" wrote in message
...
Create a line chart using the first series. Use Days as the base unit of
the axis. Add subsequent series as XY series, and make sure they are on
the primary axis. They will use the same axis, without using the same X
values as the first series.

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

"Bob" wrote in message
ups.com...
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

Thanks, both of you have very good suggestions. Kelly, you are right.
I wasn't thinking and can just connect the Xy points to make line
charts with different frequencies.

Now, I have line charts with different frequencies. Is there any way
that I can change this so that one of the series (preferrably the
annual one) is displayed as a bar chart, with the width of it taking up
the entire year instead of just being a very skinny line for one day?

Thanks,
Andrew

Kelly O'Day wrote:
Bob:

Your question says "I want line and/or bar charts, not scatter plots."

Just to make sure that the obvious is clear, you can make great looking line
chart with an XY Scatter Chart. XY Scatter Charts let you plot the points,
the points an line or just the line.

To me, line charts are actually a subset of XY charts where the X axis is a
categorical variable. Excel plots categorical variable data with similar
techniques as used with XY charts, only real difference is X axis labeling
and placement of tick marks.

Since many users are confused about Line Charts versus XY Scatter plots, any
feedback on your concerns about XY - Scatterplots would be helpful.

..Kelly




"Jon Peltier" wrote in message
...
Create a line chart using the first series. Use Days as the base unit of
the axis. Add subsequent series as XY series, and make sure they are on
the primary axis. They will use the same axis, without using the same X
values as the first series.

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

"Bob" wrote in message
ups.com...
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