ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to create combination stacked area and line chart? (https://www.excelbanter.com/charts-charting-excel/26640-how-create-combination-stacked-area-line-chart.html)

BarbAug

How to create combination stacked area and line chart?
 
I need to create a combination stacked area and line chart, but I don't see
it listed in the standard or custom chart types. How do I create?

Barb R.

The easiest way is probably to create the stacked area chart using all series
for the stacked area AND the line chart. Once you have that, select the
series that you want to change to a line chart. Right click and change that
series to a LINE chart. Voila (or as some like to say VIOLA), you've got it.

"BarbAug" wrote:

I need to create a combination stacked area and line chart, but I don't see
it listed in the standard or custom chart types. How do I create?


Jon Peltier

I have two daughters who play viola!

- Jon

Barb R. wrote:

The easiest way is probably to create the stacked area chart using all series
for the stacked area AND the line chart. Once you have that, select the
series that you want to change to a line chart. Right click and change that
series to a LINE chart. Voila (or as some like to say VIOLA), you've got it.

"BarbAug" wrote:


I need to create a combination stacked area and line chart, but I don't see
it listed in the standard or custom chart types. How do I create?



All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com