how can I fill labels in a chart, so that the grid lines don't in.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(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?
 
Hi,

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

Cheers
Andy
 
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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Axis labels offset from grid line 0
Inside Base Series Label Showing #N/A 0
Macro to change position of chart labels on line chart 1
"circular" concentric charts - like a pilot's plotting/nav computer 1
Overlay charts in 2007 2
Can we link Chart Labels to cells in the spreadsheet 1
Format Data Labels Doesn't Save 1
How to have data labels follow time adjusting line charts? 0

Back
Top