#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 97
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combo chart Doug W Charts and Charting in Excel 4 January 26th 07 04:17 AM
Create a combo chart with two of the same chart types Mark Parent Charts and Charting in Excel 2 October 14th 05 01:28 AM
Bar-Line Combo Chart mjamromi Charts and Charting in Excel 4 June 3rd 05 12:55 PM
combo chart JS Charts and Charting in Excel 3 May 18th 05 05:47 PM
combo chart conversion Arturo Charts and Charting in Excel 1 January 12th 05 09:11 PM


All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"