Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Graph based on Filtered results
Hi
I'm trying to produce a graph based on filtered results. I have a macro that autofilters the data ( ComboBox_Change) to give the number of respondents to various promotional schemes. One of the data columns ("Wards") is a list of parts of the town. The graph is to show the number of respondents, by scheme, by ward, defaulting to the whole data table if no scheme is chosen. I have the graph source data picking up the wards info, but this shows the total number of applicants by ward, and doesn't change when the ComboBox_change macro filters the data. I've had a look through past messages on this group, and it seems to require a pivot table, but that is just waaaay over my head. Does anyone have any practical advice? TIA Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to ignore zero values when plotting a graph | Charts and Charting in Excel | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) | |||
Problem with graph ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |