| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How can I create a stacked bar chart with stacked bars side by
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? "Jon Peltier" wrote: Brenda - Try some of the links I've posted he http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Brenda wrote: |
|
#2
|
|||
|
|||
|
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/ _______ TimMC wrote: 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? "Jon Peltier" wrote: Brenda - Try some of the links I've posted he http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Brenda wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel | |||
| Making Special "Stacked Column" Chart | Charts and Charting in Excel | |||
| Stacked Bar Chart | Charts and Charting in Excel | |||
| How do I create a custom scroll bar on a 3D Pivot Chart? | Charts and Charting in Excel | |||
| Chart newbie help, please, How to create | Charts and Charting in Excel | |||
Hybrid Mode
