ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can you alternate background colors by gridline? (https://www.excelbanter.com/charts-charting-excel/182088-can-you-alternate-background-colors-gridline.html)

Mikey

Can you alternate background colors by gridline?
 
I have a chart where the horizontal axis is dates with the major gridlines
every seven days. To make the chart easier to read I'd like to alternate the
colors of background colors on the chart at each major gridline. Is this
possible? If so, how would I do it?

Jon Peltier

Can you alternate background colors by gridline?
 
http://peltiertech.com/Excel/ChartsH...orizBands.html

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


"Mikey" wrote in message
...
I have a chart where the horizontal axis is dates with the major gridlines
every seven days. To make the chart easier to read I'd like to alternate
the
colors of background colors on the chart at each major gridline. Is this
possible? If so, how would I do it?





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

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