| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Stacked area and area chart combo
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 |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Stacked area and area chart combo
If you want to email me direct, do not post to NG, an example I will
take a look. Cheers Andy wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| 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 | |||
| Dynamic Stacked Column Chart Help | Charts and Charting in Excel | |||
| How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
| How to create combination stacked area and line chart? | Charts and Charting in Excel | |||
| Stacked column and column combo chart | Charts and Charting in Excel | |||
Hybrid Mode
