Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
ju1eshart
 
Posts: n/a
Default Edit colour of one gridline in a 3D chart

How can one gridline be edited to change colour in ad 3d bar chart. Thanks in
advance for your help.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Edit colour of one gridline in a 3D chart

Hi,

You can not colour individual grid lines in either 2d or 3d charts.

With 2d charts you have the ability to add a dummy series to represent a
grid line.

For examples of this technique see,
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm

Cheers
Andy


ju1eshart wrote:
How can one gridline be edited to change colour in ad 3d bar chart. Thanks in
advance for your help.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
Maintain colour changes in a Pivot Chart when changing Pivot value rdickfos Charts and Charting in Excel 1 April 11th 06 09:05 AM
After an upgrade could not open and edit an embedded chart. tdriesbaugh Charts and Charting in Excel 0 March 29th 06 03:15 PM
Bubble Chart Colour Darren. Charts and Charting in Excel 0 March 10th 06 11:01 AM
Updating a chart automatically jeffsumm Charts and Charting in Excel 4 December 28th 05 09:01 PM
updating chart using edit query Chandler Charts and Charting in Excel 0 May 16th 05 06:14 PM


All times are GMT +1. The time now is 03:23 PM.

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

About Us

"It's about Microsoft Excel"