Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 152
Default Multiple types of charts in one chart

Is it possible to do the following:

Stacked bar chart for 3 data series.
Regular bar chart for 1 data series.
Line chart for 1 data series.

I've used the custom "line-bar chart 2 axes" combination chart which nearly
solves the issue, except that it won't allow me to split up the bar charts.

Alternatively, I've also managed to get it "working" except that the bar
charts block each other. Is there a way of shifting the bar charts so they do
not overlap?

I am using Office 2003.
Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 915
Default Multiple types of charts in one chart

Alan wrote:
Is it possible to do the following:

Stacked bar chart for 3 data series.
Regular bar chart for 1 data series.
Line chart for 1 data series.

I've used the custom "line-bar chart 2 axes" combination chart which nearly
solves the issue, except that it won't allow me to split up the bar charts.

Alternatively, I've also managed to get it "working" except that the bar
charts block each other. Is there a way of shifting the bar charts so they do
not overlap?

I am using Office 2003.
Thanks!


Put all your stuff in some chart. When viewing the chart, right click a
series, select "chart type", and pick your fave for that series.

Rinse and repeat.
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
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" roadsidetree Charts and Charting in Excel 15 June 2nd 09 10:53 AM
multiple chart types on pivot BorisS Charts and Charting in Excel 0 July 6th 07 04:44 PM
Cannot combine stock charts with other chart types in Excel 2007 rrr Charts and Charting in Excel 2 January 15th 07 06:40 PM
How do I share User-Defined Custom Chart Types in Pivot Charts? jantz_question Charts and Charting in Excel 0 September 20th 05 01:39 PM
Charts Line Types for Multiple Data Series not Printing Properly Seanb Charts and Charting in Excel 0 August 22nd 05 06:35 PM


All times are GMT +1. The time now is 09:02 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"