Is it possible to be able to filter by a particular field and use the same field as a series name in a Pivot Chart?
The chart is showing a count of the number of issues per supplier over a un/filtered date range. The chart is based on a query which receives criteria from a generic form to filter results accordingly in other forms.
The end user wants to be able to select a variable amount of suppliers while still being able to see the suppliers separated, if that makes sense. Right now the filter aggregates everything into one column which is undesirable.
I will am comfortable with using VBA if that is what it will take. For some reason this is now a key thing to have in this database even though they do not do anything like this currently. :banghead:
I wanted to export to Excel and do everything there, however I am completely clueless on how to do it or where to begin so I am taking a chance doing it all in Access. Information on how to get it all into Excel will be appreciated if that is indeed the easier path to take.
The chart is showing a count of the number of issues per supplier over a un/filtered date range. The chart is based on a query which receives criteria from a generic form to filter results accordingly in other forms.
The end user wants to be able to select a variable amount of suppliers while still being able to see the suppliers separated, if that makes sense. Right now the filter aggregates everything into one column which is undesirable.
I will am comfortable with using VBA if that is what it will take. For some reason this is now a key thing to have in this database even though they do not do anything like this currently. :banghead:
I wanted to export to Excel and do everything there, however I am completely clueless on how to do it or where to begin so I am taking a chance doing it all in Access. Information on how to get it all into Excel will be appreciated if that is indeed the easier path to take.