100% stacked chart and secondary axis

T

tommy h

How can I create a 100% stacked bar chart with a secondary
axis showing data by a line?

Thank you for any help
 
J

Jon Peltier

Tommy -

Plot all your data as 100% stacked column. Then right-click the one
series you want to switch, choose Chart TYpe from the pop up menu, and
select Line. To put this line on the other axis, double click on it,
and on the Axis tab, select Secondary.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Anyway to plot a stacked bar and bar chart on Primary and Secondary axis? 2
secondary category axis reset to min=0 max=0 on save 1
Stacked Bar Chart with Secondary Axis 7
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? 1
Column Chart With Averages Displayed 1
stacked column graph adjacent to a regular column graph 0
Pivot Chart Refresh cancels all chart formatting 2
Trendline in a stacked graph chart 1

Top