is there a way to only graph numbers above a certain measure
 

say i have amount of money in column a all the way to a50. the amount
ranges between $400 dollars and $5000 dollars. is there a way to only
plot the data points above $1000?


--
kckar
------------------------------------------------------------------------
kckar's Profile: http://www.excelforum.com/member.php...o&userid=25322
View this thread: http://www.excelforum.com/showthread...hreadid=513084

is there a way to only graph numbers above a certain measure
 

Hi kckar,
If you apply Autofilter--Custom--is greater than--1000, and if
Tools--Options-- Chart-- Active Chart -- "Plot visible cells only"
is checked then that should do it.
Ken Johnson