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

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

[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