How can I create a stacked bar chart with stacked bars side by si.

  • Thread starter Thread starter Guest
  • Start date Start date
Any way to have a stacked bar chart to represent the total of value a and
value b. Then add a horizontal line displaying a third value?
 
Tim -

Make your chart with all three series as a stacked column. Then select the series
which is to be a horizontal line, and using Chart Type from the Chart menu, select a
line chart type.

Alternatively, add a horizontal line using one of these procedures:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

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

Stack Bar Charts 1
Stacked bar Chart in Excel 2007 1
Multiple stacked clustered bars 1
Excel How to create a stacked bar graph 0
Stacked bar charts 1
Stacked bar chart with totals - Excel 2003 2
Stacked Bar Chart 1
how do I create a stacked bar chart on 2 axis> 2

Back
Top