ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Bug with gradient fills and max scale (https://www.excelbanter.com/charts-charting-excel/133706-bug-gradient-fills-max-scale.html)

marcus

Bug with gradient fills and max scale
 
I have a bar chart with gradient fills. The bar chart has a max value set so
some bars are cut off. This chart is displayed in a picture link. In this
picture the bars continue "through the roof" of the chart. Has anyone else
encountered this? I can solve it by having solid fills, is there another way?

Jon Peltier

Bug with gradient fills and max scale
 
My advice is to use solid fills. Not only is it simpler, but sometimes
gradients can distract the reader or imply certain things about the data.

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


"Marcus" wrote in message
...
I have a bar chart with gradient fills. The bar chart has a max value set
so
some bars are cut off. This chart is displayed in a picture link. In this
picture the bars continue "through the roof" of the chart. Has anyone else
encountered this? I can solve it by having solid fills, is there another
way?





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

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