Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
limiting chart source data with criteria?
I know for a series you choose:
Values: =A2:A10 is there anyway to limit it further by saying something to the effect of Values: =A2:10 but not equal to 0, like Values =A2:A10 < 0 (I know that doesnt work, already tried it, but its kinda what I want to accomplish) I can go in and manually ctrl click through to limit the data source, but thats a pain, I'd rather choose 1 big block and have some statement exclude 0 values. I could sort the data....but according to my boss thats not an option, because she wants the order to be the same quarter to quarter no matter what the values. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line disappearing from chart after changing data source | Charts and Charting in Excel | |||
I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
Can't change source data path for Pivot Chart | Charts and Charting in Excel | |||
recovering chart source data from deleted files | Excel Discussion (Misc queries) | |||
Data Source Name Not Found | Excel Worksheet Functions |