Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you change the color of only one axis line?
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you change the color of only one axis line?
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...nes/index.html http://processtrends.com/pg_charts_horizontal_line.htm Cheers Andy Jim Moberg wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel chart draws line outside Y axis | Charts and Charting in Excel | |||
Change individual series from bar to line | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Phase change line on a graph? | Excel Discussion (Misc queries) | |||
Producing line and bar graphs on same axis | Charts and Charting in Excel |