ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   I want to make a two tone chart background (https://www.excelbanter.com/charts-charting-excel/239374-i-want-make-two-tone-chart-background.html)

Frank

I want to make a two tone chart background
 
I am creating a chart and want the chart background above a certain value to
be of a different color (to indicate a maximum allowable value has been
exceeded). An alternative would be to jus have the gridline & axis value of
a different color/thickness/etc

Luke M

I want to make a two tone chart background
 
Basically, you'll need to create some dummy series. Jon Peltier gives
excellent examples of how to create horizontal bands he

http://peltiertech.com/Excel/ChartsH...orizBands.html

Other background fills:

http://peltiertech.com/Excel/Charts/BackgroundFill.html
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Frank" wrote:

I am creating a chart and want the chart background above a certain value to
be of a different color (to indicate a maximum allowable value has been
exceeded). An alternative would be to jus have the gridline & axis value of
a different color/thickness/etc



All times are GMT +1. The time now is 06:31 AM.

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