Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I combine a line and a percentage stacked column chart?
I would like to combine stacked percentage columns on the primary axis with
lines on the secondary. |
#2
|
|||
|
|||
If it were me, I'd create a stacked chart with all of the data. I'd then
double click on the data series for the secondary axis to get FORMAT DATA SERIES. I'd select the AXIS tab and choose secondary. 'd then right click on the same data series that is to be made into a LINE chart. You'll see Chart Type as an option. Change the chart type for the series to LINE. You may need to adjust your scaling for the secondary axis. "Liza" wrote in message ... I would like to combine stacked percentage columns on the primary axis with lines on the secondary. |
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 | |||
Combine candle and line in a single chart | Charts and Charting in Excel | |||
Column Chart to Line Chart | New Users to Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |