Can you change the color of only one axis line?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Moberg - 20 Oct 2006 21:52 GMT

Is it possible to change the color of just one axis line on a chart? It
would be nice because then we could mark in red which would allow us to see
target values we are shooting for and then see how the actual results measure
up.

Reply to this Message

Andy Pope - 21 Oct 2006 13:45 GMT

Hi,

You can not colour an individual gridline.

But here are some examples of how to add a datum line to your chart.

http://www.andypope.info/charts/averageline.htm
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts/straight_lines/index.html
http://processtrends.com/pg_charts_horizontal_line.htm

Cheers
Andy

> Is it possible to change the color of just one axis line on a chart? It
> would be nice because then we could mark in red which would allow us to see
> target values we are shooting for and then see how the actual results measure
> up.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message