ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   category (X) axis gridlines (https://www.excelbanter.com/charts-charting-excel/182496-category-x-axis-gridlines.html)

mwpyoung1

category (X) axis gridlines
 
Why would category (X) axis gridlines be useful in a chart

Jon Peltier

category (X) axis gridlines
 
Why would value (Y) axis gridlines be useful?

It's true that often gridlines are unnecessary, and the default formatting
in Excel is so bold that the gridlines detract from the data. However, in an
XY chart, the X axis is used just like the Y axis, to plot numerical values
proportionally to their values. And in a date scale axis, a major gridline
every week helps to make the data easier to interpret. For gridlines, I like
to use light gray; in my custom palette, I modify the default light gray to
two shades lighter.

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


"mwpyoung1" wrote in message
...
Why would category (X) axis gridlines be useful in a chart





All times are GMT +1. The time now is 05:39 AM.

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