Hello,
to start with I am not very experienced with excel.
I have a spreadsheet with data that is used like a database. I need to apply criteria to several columns and sum up the entries of another column of the result rows. The result will be used in conjunction with a modifiable number to create a pie-chart. Now that could easily be done by just applying filters. But I need multiple of those piecharts each for other criteria and all displayed at the same time in the same table.
Is there a way to save the filter criteria and add them to a piechart so that the piechart always uses this filter on the data?
I am versed in SQL and thought maybe it is possible to do it this way. Like putting a SELECT SUM(...) ... WHERE ... statement into a cell and using the result for the piechart. But I don't know if that is possible in excel.
A very messy way would be to create multiple tables and each of them has a query with it's criteria and then another table where all the pie charts are using the queries of the respective table. But I would use this only as a last resort solution.
Best regards
Michael
to start with I am not very experienced with excel.
I have a spreadsheet with data that is used like a database. I need to apply criteria to several columns and sum up the entries of another column of the result rows. The result will be used in conjunction with a modifiable number to create a pie-chart. Now that could easily be done by just applying filters. But I need multiple of those piecharts each for other criteria and all displayed at the same time in the same table.
Is there a way to save the filter criteria and add them to a piechart so that the piechart always uses this filter on the data?
I am versed in SQL and thought maybe it is possible to do it this way. Like putting a SELECT SUM(...) ... WHERE ... statement into a cell and using the result for the piechart. But I don't know if that is possible in excel.
A very messy way would be to create multiple tables and each of them has a query with it's criteria and then another table where all the pie charts are using the queries of the respective table. But I would use this only as a last resort solution.
Best regards
Michael
