ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Combination chart - area and column - order display? (https://www.excelbanter.com/charts-charting-excel/63180-combination-chart-area-column-order-display.html)

Gary King

Combination chart - area and column - order display?
 
The area element displays behind the column element(s). How can I order the
elements so that the area element is in front?

TIA

--
Gary King

Andy Pope

Combination chart - area and column - order display?
 
Hi,

The various chart types plot on different layers.
Line/xy-scatter in front of bar/column in front of area in front of
pie/radar/donut. The items on the secondary axis are plotted in front of
primary axis but only within types.

The only way I can think of bring area in front of columns is to make
the chart completely out of series plotted as area.
This example demonstrates how to plot variable width columns using an
area charts. Maybe you can use this technique to create the columns and
the area.
http://www.andypope.info/charts/colwidth2.htm

Cheers
Andy

Gary King wrote:
The area element displays behind the column element(s). How can I order the
elements so that the area element is in front?

TIA


--

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


All times are GMT +1. The time now is 09:11 PM.

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