scatter plot options

[chazz]

ok, here's one for you.

remember scatterplots? I'd like to vary the color of the points according to their position in the array.

any ideas?

thx.

 

[venkat1926]

this posting is a slight modificationof a posting in the newsgroup

See the sample sheet below.
Notice the formulas in column C
Choose in the second step chart wizard “series”(in the first step you have chosen scatter chart)
Cilick add and reference x values as A2 to A8 and y values as B2 to b8
Click again add and reference x values as A2 to A8 and y values as C2 to C8
The chart is designed to show points y values above 5 in red(defailt)
You right click the red point and click format data series and change MARKER style and foreground foreground color
You modify the formula in column C and modify the chart as required. By you.
venkat

Book1
	A	B	C	D
1	XAXIS	YAXIS	YAXIS
2	16	1	#N/A
3	20	2	#N/A
4	16	3	#N/A
5	12	4	#N/A
6	19	5	#N/A
7	16	6	6
8	11	7	7
Sheet1

 

[chazz]

thank you -- I will play around with this a bit.