Recommendation Combine Stacked Column And Line Chart Excel
Now lets add the next series.
Combine stacked column and line chart excel. I need to create a stacked Column Chart with the data. Excel allows us to combine different chart types in one chart. Dont use a custom chart type.
Bar and Line Graph. After selecting the data as mentioned above and selecting a stacked column chart. Replied on February 18 2011.
Sometimes you need to display data in a column chart. Click on Change Chart Type or carefully right-click on the selected series takes a steady hand. In Column chart options you will see several options.
Add the new series to the stacked bar chart - itll become one of the stacked series. Then select Chart Chart Type Line. Thread starter Naveen N.
This type of chart is not available in the standar. Next we change the chart type. First select A2G5 and create a column chart of all six series.
Right-click on one series you want to switch choose Chart Typefrom the popup menu and select a Line series with markers and lines. Also Column J should be a line chart. You should see the first part of your stacked column graph appear.