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!

 

[Bob Tulk]

Real simple. Create the chart of one set of data (so
volumes on the y-axis, months on the x-axis and one line
representing year 1).

Assuming the data is in one table, like this:

Month Yr1 Yr2
Jan 123 234
Feb 345 456
etc.

Highlight the second year's data. Place your mouse
pointer over the edge of the selected cells (will now turn
into an arrow instead of the regular cross). Click and
drag, with your left mouse button, the range to your chart
and release. Excel automatically adds the data as a
second line/bar.

Now with the two series of data shown, simply select the
line/bar that you want to turn into a line/bar. Then
choose CHART | CHART TYPE and pick the new type.