View Single Post
  #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