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?
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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks