| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to format alphanumeric cells as numbers | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| How do I graph this? | Charts and Charting in Excel | |||
| Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Hybrid Mode
