Combining Stack bar and Line Charts

[tibor]

I'm trying to display 2 sets of data within the same chart; I want to
display yr 1 data in a stacked bar format and yr 2 data in a line
format. Both data sets would use the same axis; month and volume. I
need to distinctively display each mo/yr together to show any increases
or decreases in volume. Any suggestions you have are appreciated!

 

[Jon Peltier]

Tibor -

Do you have multiple series per year?

If not, the data looks like this:

2002 2003
Alpha 55 65
Beta 42 59
Gamma 37 62

(Maybe you have months instead of greek letters.) Select the range and
make a column chart. Right click on the 2003 series, select Chart Type
from the pop up menu, and select an appropriate Line chart type.

If you have multiple series for each year, do the same, start with a
stacked column chart with all the data, change the chart type of one
series as above, then select each additional one and press F4 to repeat
the chart type assignment.

Tip within a tip. There are two friendly buttons described here.
Introduce yourself to them, because they are your good friends: the
right mouse button, and the F4 key. I use them all the time.

- Jon