ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   multiple colors on format of plot area (https://www.excelbanter.com/charts-charting-excel/161838-multiple-colors-format-plot-area.html)

BillO

multiple colors on format of plot area
 
How can I change the format of the plot area to multiple colors.

for example I would like to have a Bar Chart with the background plot area
starting @ blue , then Green, then Red. Then have the temperature bars
plot over this area.

thanks

John Mansfield

multiple colors on format of plot area
 
You can do so by bringing a stacked column chart into the mix.

Please see Jon's example below:

http://peltiertech.com/Excel/Charts/...ackground.html

--
John Mansfield
http://cellmatrix.net





"BillO" wrote:

How can I change the format of the plot area to multiple colors.

for example I would like to have a Bar Chart with the background plot area
starting @ blue , then Green, then Red. Then have the temperature bars
plot over this area.

thanks



All times are GMT +1. The time now is 04:29 AM.

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