Changing the color on the line graph

[alien1507]

Hi,

I need to change color on a line graph, but not color for the complete line, just for one change.

For example. I have 5 entries. 1, 2, 3, 4 and 5. I want that from 1 to 3 is blue color, from 3 to 4 red color and from 4 to 5 again blue color of the line.

Please help

 

[dave3009]

Hi alien1507

Try plotting two series, one from 1 to 5 and the other from 3 to 4. I have copied a sample table below, when plotted on a standard line chart it changes part of the line.

Excel 2007
	A	B	C
1		PL1	PL2
2	A	1
3	B	2
4	C	3	3
5	D	4	4
6	E	5
Sheet8

HTH

Dave

 

[Lornup938]

if you want to change multiple lines, select the first line, and then press and hold ctrl while you select the other lines.


under drawing tools, on the format tab, in the shape styles group, click the arrow next to shape outline.


i advice you. you use microsoft excel 2007.

 

[alien1507]

Can any one of you send me your email address, so that I can send you excel document and explain what is to be done. I can't do it in either way.

 

[dave3009]

Hi alien1507,

I'm not sure that would necessarily help, You wanted to be able to colour a part of a line on a line chart between two values. The trick is an illusion of that, you plot two lines that hold the same data just remove the bits before and after the section you don't want coloured.

Given your example question I put these two together, I highlighted the ranges on the left, then...Insert > Charts > Line > 2D Line. That was all

Perhaps you could elaborate on your example. You will find a link to some add-ins in my signature block that will help you post your data to the board, they are no different from opening up a workbook so no special software installations