Colors on VBA

[tennisplayer]

On VBA, how do you make half a graph one color and the other half of the same graph a different color?

 

[dave3009]

No entirely sure what you mean but....Why not plot two sets of data and set a different colour for each one

Excel Workbook
	A	B	C	D
1	Name	Data	Plot1	Plot2
2	a	152	152	#N/A
3	b	50	50	#N/A
4	c	34	34	#N/A
5	d	56	#N/A	56
6	e	198	#N/A	198
7	f	115	#N/A	115
Sheet1

Excel 2007

Cell Formulas
Range	Formula
C2	=IF(ROW()-1<=COUNTA($A$2:$A$7)/2, B2, NA())
D2	=IF(ROW()-1>COUNTA($A$2:$A$7)/2, B2, NA())

The result

 

[tennisplayer]

But how would you make it so that for example for a line-scatter plot A2-A7 is one color while A8:A15 is another color?

 

[dave3009]

I tried a similar data set on both a line and scatter plot and here was the result

 

[tennisplayer]

Thank you!
can you elaborate on what you did in order to plot those points on a graph?

 

[dave3009]

Using a dataset similar to the set above (slightly bigger) I highlighted columns A, C & D and inserted a chart based on them. The colours were the default colour, there are two ranges being plotted so they should automatically be different