| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Growing/Shrinking/Selective Chart Data
I'm looking for a Dynamic means of populating a bar chart.
Cloumn A (Rows 2-200) Has the Names (Y Axis) of each Item and Cloumn B (Rows 2-200) (X Axis) has the Number Values. My problem is twofold... One, every week the Y axis list can grow or shrink and Two, I only want to show those that have an X Axis value that is greater than five. Anything less than or equal to five I would like to have hidden from showing in the chart. Is it possible to have some sort of way or formula that can make this possible in a chart or in pivot table? Thanks in Advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a chart with selective (discontinuous) data? | Charts and Charting in Excel | |||
| Charting selective data | Excel Discussion (Misc queries) | |||
| Selective legend in Chart? | Excel Discussion (Misc queries) | |||
| HOW DO I KEEP DATA (SPREADSHEET EXCEL) FROM SHRINKING WHEN SAVED? | Excel Discussion (Misc queries) | |||
| Selective stacking of columns in a chart | Excel Discussion (Misc queries) | |||
Threaded Mode
