Stacked Bar and Line Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hartster - 09 May 2007 21:54 GMT

This should be an easy graph to produce but I'll be darned if I can figure
out how to do it in power point.

Essentially I have 3 sets of numbers I want the first set and second set to
stack as a bar chart and the 3rd set to be a line chart.

I know how to create side by side bar charts and a line chart but I can't
figure out how to create a stacked bar chart with a line chart. Note the line
chart is not a trendline - it's a totally separate variable.

Thanks for any help.

Reply to this Message

Echo S - 09 May 2007 22:28 GMT

Right-click the chart, choose chart type and select one of the stacked chart
options. All 3 sets of data will be stacked.

Right-click the data series you want to be a line, choose chart type, then
choose Line Chart type. That will change the one data series to a line.

I know, it's not intuitive at all.

Signature

Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/

> This should be an easy graph to produce but I'll be darned if I can figure
> out how to do it in power point.
[quoted text clipped - 9 lines]
>
> Thanks for any help.

Reply to this Message