Combo chart?

[Joe M.]

I would like to create a chart that uses 2 different styles at the same time.
I would like to plot a line showing the revenue each month over a year but in
the background show the periods of time where certain events occur during the
year which would effect revenue. Perhaps a shading of the plot area to
indicate the events. Maybe kind of a bar graph underneath without separation
between the months. Anyone have any ideas?
Thanks,
Joe M.

 

[Bob Phillips]

Plot a chart of just one type, then just select one of the series,
right-click, select Chart Type, and change the chart type for that series.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)