Max of Chart

[CT Witter]

I would like to get the max of a chart. Ie. if I have the data

1 2
2 3
4 4
5 3
6 2

The max would occur at 4,4. Is there a way for me to designate this in the data table.

Thanks,
CT

 

[Mark W.]

Sure. Just add another series [e.g., =SERIES("Max",Sheet2!$A$1:$A$5,Sheet2!$C$1:$C$5,2)] to your chart (as shown in column C below) and set it's line/marker attribute to "None".

Book1
	A	B	C	D	E	F	G	H	I	J
1	1	2	#N/A
2	2	3	#N/A
3	4	4	4
4	5	3	#N/A
5	6	2	#N/A
Sheet2

 

[CT Witter]

Thanks!! That worked Great!