ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how can I fill labels in a chart, so that the grid lines don't in. (https://www.excelbanter.com/charts-charting-excel/13483-how-can-i-fill-labels-chart-so-grid-lines-dont.html)

peterk

how can I fill labels in a chart, so that the grid lines don't in.
 
(Excel:)
How can I fill labels in a chart, so that the grid lines of that chart do
not interfere with the text in those labels?

Andy Pope

Hi,

Double click the data labels and set the Patterns Area colour to be the
same as the plotarea colour.

Cheers
Andy

peterk wrote:
(Excel:)
How can I fill labels in a chart, so that the grid lines of that chart do
not interfere with the text in those labels?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Jon Peltier

Peter -

Or you could double click the gridlines and change their color to the
faintest gray in the palette (you've already changed the plot area
background to white, haven't you?). Black gridlines attract too much
attention.

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

peterk wrote:

(Excel:)
How can I fill labels in a chart, so that the grid lines of that chart do
not interfere with the text in those labels?



All times are GMT +1. The time now is 12:52 AM.

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