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
Bookmarks