If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I have one gridline in chart a different colour
I want to show the minium and maximum temp lines on a chart to show when the
temps have gone over or under - clearly. How can I change ONE gridline to another colour/style? Also in the spreadsheet I would like a similar thing. Every time I place a number in that is over or under certain amounts - I would want that figure to automatcially show in a colours or flash etc. |
#2
|
|||
|
|||
How do I have one gridline in chart a different colour
Hi,
You can not format individual gridlines. But you can work around the problem by adding extra data series to plot the lines. Here is a collection of examples. http://peltiertech.com/Excel/Charts/RunChtLines.html http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm As for changing the cells when certain values are entered you need to look at Conditional Formatting under the Format menu. For an explanation see, http://www.contextures.com/xlCondFormat01.html Cheers Andy Jennie Wren wrote: I want to show the minium and maximum temp lines on a chart to show when the temps have gone over or under - clearly. How can I change ONE gridline to another colour/style? Also in the spreadsheet I would like a similar thing. Every time I place a number in that is over or under certain amounts - I would want that figure to automatcially show in a colours or flash etc. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart Property Confusion | Arturo | Charts and Charting | 4 | December 16th, 2005 05:13 AM |
Radar Chart - How to include X axis gridline | Michelle | Charts and Charting | 1 | December 7th, 2005 09:30 AM |
how do I keep my data series colour when I refresh a pivot chart | reghog | Charts and Charting | 1 | November 29th, 2005 01:23 PM |
Colour gradient excel chart pasted in word will only print in grey | Shauna Kelly | General Discussion | 2 | April 21st, 2005 09:52 AM |
How do I change the inverse colour in an Excel chart? | david_hutton.NO_SPAM | Charts and Charting | 3 | February 21st, 2005 12:16 PM |