ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo chart? (https://www.excelbanter.com/excel-discussion-misc-queries/189369-combo-chart.html)

Joe M.

Combo chart?
 
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

Combo chart?
 
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)

"Joe M." wrote in message
...
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.





All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com