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

K

kckar

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?
 
K

Ken Johnson

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
 
Top