Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom Chart: Stacked Bar & Line
I would like to combine a stacked bar graph and line graph. I can do this
with a regular bar graph and line graph, but not with a stacked bar graph. Any ideas on how to do this? I will use the same y-axis values for both the line and stacked bar. Thanks, \JG |
#2
|
|||
|
|||
Hi Jim -
Make your stacked column chart, including the data for the line series as another stacked column. Then select this series, goto the Chart menu, choose Chart Type, and select a Line chart style. (When you select one series, the Chart Type adjustment only applies to that series.) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Jim Garman wrote: I would like to combine a stacked bar graph and line graph. I can do this with a regular bar graph and line graph, but not with a stacked bar graph. Any ideas on how to do this? I will use the same y-axis values for both the line and stacked bar. Thanks, \JG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add line to a stacked area chart already created | Charts and Charting in Excel | |||
Create a custom chart, two stacked bars/month w/ two axes? | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel | |||
How do I combine a line and a percentage stacked column chart? | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |