Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Colour part of a line on an X Y graph
I have an XY graph which connects the series with a line. Lets say the
series runs left to right on the chart creating a straight horizontal line. Is it possible to have multiple colours on that line? That is, I want to colour certain portion of the line a certain colour and other portion another colour. Is this possible |
#2
|
|||
|
|||
Hi,
You can format the line between points by selecting the series and then selecting the specific line segment. Use CTRL+1 to bring up the format dialog. Note that formatting the line segment will affect the legend so you might be better off plotting additional data series with gaps in the data. Cheers Andy ExcelMonkey wrote: I have an XY graph which connects the series with a line. Lets say the series runs left to right on the chart creating a straight horizontal line. Is it possible to have multiple colours on that line? That is, I want to colour certain portion of the line a certain colour and other portion another colour. Is this possible -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How do you fit a line to a graph? | Excel Discussion (Misc queries) | |||
Line and Column Graph | Charts and Charting in Excel | |||
Can you have a vertical line graph in Excel 2003 | Charts and Charting in Excel | |||
How do I "index" data in a line graph? | Charts and Charting in Excel |