ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Edit colour of one gridline in a 3D chart (https://www.excelbanter.com/charts-charting-excel/91438-edit-colour-one-gridline-3d-chart.html)

ju1eshart

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.

Andy Pope

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


All times are GMT +1. The time now is 11:28 PM.

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