Dynamic Results Report

[eirini]

Is it possible to create a Dynamic Results Report in excel by choosing graphs and tables (of various sizes and column/ rows lengths and heights) across multiple sheets of a workbook?
the user should be allowed to choose which graphs/ tables to include in the report by using checkboxes.
Is there some add-in to facilitate the process?
Or could you please point me to a sample file?

Thank you!

 

[Luke M]

What you are describing is known as a dashboard. Chandoo has many wonderful articles about these.
http://chandoo.org/wp/excel-dashboards/
http://chandoo.org/wp/excel-dashboards/examples/

With any dashboard, you can change what gets plotted on a chart, and you could use hidden/unhidden rows to display the charts that you want. You have a bit of reading to do, but we've got the resources to help you.

 

[eirini]

dashboards do look nice but I am not sure if they do what I need...
The aim is to have dynamic content, in terms of types of tables and charts.
for example, a user may want to see charts 2-3 and 5 in their report, while someone else may choose tables 2-4 and charts 5-6.
Are dashboards suitable for this?

 

[Luke M]

Here's one way to dynamically show charts:
http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/

You could elaborate on this technique to use Checkboxes or something, all of which would hide/unhide whatever you want.
And then there's also VB, if you need to get really intensive.