I prefer, and so do the users, the "click this slicer button" to make changes and show data.
Here's my weak thinking
data on select.survey
data needs to be stored.
data comes out as a single table.
store in access
slice up
link excel to access (because graphs and slicer control)
Is there anything wrong with using excel to do the graphing here?
Most of the users will want something they can open up, knowing the data has been done, and they can just click some buttons and get some graphs.
I prefer, and so do the users, the "click this slicer button" to make changes and show data.
Here's my weak thinking
data on select.survey
data needs to be stored.
data comes out as a single table.
store in access
slice up
link excel to access (because graphs and slicer control)
Is there anything wrong with using excel to do the graphing here?
Most of the users will want something they can open up, knowing the data has been done, and they can just click some buttons and get some graphs.