ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Multiple types of charts in one chart (https://www.excelbanter.com/charts-charting-excel/197873-multiple-types-charts-one-chart.html)

Alan

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!

smartin

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.


All times are GMT +1. The time now is 02:22 PM.

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