ExcelBanter - Stacked area and area chart combo

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Stacked area and area chart combo (https://www.excelbanter.com/charts-charting-excel/105619-stacked-area-area-chart-combo.html)

Stacked area and area chart combo

Is it possible to create a stacked area and area combo chart. I have 2
series that need to be stacked and one that needs to be just area. If I
change the one, it changes all.

Stacked area and area chart combo

Hi,

Move the series that is not to be stacked on to the secondary axis.
Double click series and check secondary on the axis tab.

You may have to play with the scale values in order to stop the single
area masking the stacked areas. Unless of course that is what you want
to do.

Cheers
Andy

wrote:
Is it possible to create a stacked area and area combo chart. I have 2
series that need to be stacked and one that needs to be just area. If I
change the one, it changes all.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Stacked area and area chart combo

I'm using a scatter plot on the secondary axis. Any other options?

Andy Pope wrote:
Hi,

Move the series that is not to be stacked on to the secondary axis.
Double click series and check secondary on the axis tab.

You may have to play with the scale values in order to stop the single
area masking the stacked areas. Unless of course that is what you want
to do.

Cheers
Andy

wrote:
Is it possible to create a stacked area and area combo chart. I have 2
series that need to be stacked and one that needs to be just area. If I
change the one, it changes all.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Stacked area and area chart combo

Are the series all using the same X values, but you have a secondary X axis
anyway? If so, double click the secondary Y axis and uncheck the Category
Axis Crosses at Maximum Value box.

If you need the secondary X axis, you have to have two stacked (not
unstacked) Area series on the secondary axis, where the first has values of
zero. This series goes from the axis (at the top) to zero, and the
meaningful series stacks on it, meaning it now starts at zero. You have to
hide the first of these by formatting it with no border or fill.

I imagine you could make a more readable chart using another combination of
chart types. Area charts can be difficult to interpret, especially if you
have one series in front of others. Why not use a Line chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

wrote in message
ps.com...
I tried it but my area chart on the secondary axis gets flipped upside
down

Andy Pope wrote:
That should not be a problem.

I just built a chart with

2 series stacked area on primary
1 area on secondary
1 xy-scatter on secondary

Did you try it and it failed?

Cheers
Andy

wrote:
I'm using a scatter plot on the secondary axis. Any other options?

Andy Pope wrote:

Hi,

Move the series that is not to be stacked on to the secondary axis.
Double click series and check secondary on the axis tab.

You may have to play with the scale values in order to stop the single
area masking the stacked areas. Unless of course that is what you want
to do.

Cheers
Andy

wrote:

Is it possible to create a stacked area and area combo chart. I have 2
series that need to be stacked and one that needs to be just area. If
I
change the one, it changes all.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info