Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 16th 05, 10:59 PM
peterk
 
Posts: n/a
Default 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?

  #2   Report Post  
Old February 17th 05, 09:10 AM
Andy Pope
 
Posts: n/a
Default

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
  #3   Report Post  
Old February 18th 05, 01:52 AM
Jon Peltier
 
Posts: n/a
Default

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Labels on a chart Kevin Charts and Charting in Excel 1 February 10th 05 09:16 AM
Pie Chart Data Labels gb_S49 Charts and Charting in Excel 4 January 26th 05 02:37 PM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 05:54 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017