How can one gridline be edited to change colour in ad 3d bar chart. Thanks in advance for your help.
J ju1eshart May 31, 2006 #1 How can one gridline be edited to change colour in ad 3d bar chart. Thanks in advance for your help.
A Andy Pope May 31, 2006 #2 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/straight_lines/index.html http://www.andypope.info/charts/averageline.htm Cheers Andy
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/straight_lines/index.html http://www.andypope.info/charts/averageline.htm Cheers Andy
