close

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: www.excelforum.com/member.php...oamp;userid=25322
View this thread: www.excelforum.com/showthread...hreadid=513084Hi kckar,
If you apply Autofilter--gt;Custom--gt;is greater than--gt;1000, and if
Tools--gt;Options--gt; Chart--gt; Active Chart --gt; quot;Plot visible cells onlyquot;
is checked then that should do it.
Ken Johnson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()