Hello,
I am currently creating a dynamic dashboard.
I want to be able to see on a pivot table and on a chart, data visualized either by week, either by month.
I have done this with VBA it works fine, see the file in attached.
For this I dynamically modfy a table data (in sheet CALC_CHART) based on the pivot table, then the chart use the data of this table. Indeed, in my real dashboard, there is several data columns and several charts, so use a basic chart linked to the pivot table, is not a good solution for me, because, the chart would display ALL the data columns of the pivot table in this case. And I want to show only some data column, depending of charts concerned. With this dynamic table I can use only one source, for several charts.
The file in attached is simplfied with only one data column. So don't tell me to use a chart based on the pivot table in this case
I'm wondering if there is a way to do the same kind of "dashboard' WITHOUT VBA ? Perhaps/probably I use VBA while it is not necessary.
* How could I dynamically change the pivot field (week or month) of the pivot table ?
* How could I dynamically update the chart too accordingly ?
Thank you for your ideas and experience
I am currently creating a dynamic dashboard.
I want to be able to see on a pivot table and on a chart, data visualized either by week, either by month.
I have done this with VBA it works fine, see the file in attached.
For this I dynamically modfy a table data (in sheet CALC_CHART) based on the pivot table, then the chart use the data of this table. Indeed, in my real dashboard, there is several data columns and several charts, so use a basic chart linked to the pivot table, is not a good solution for me, because, the chart would display ALL the data columns of the pivot table in this case. And I want to show only some data column, depending of charts concerned. With this dynamic table I can use only one source, for several charts.
The file in attached is simplfied with only one data column. So don't tell me to use a chart based on the pivot table in this case
I'm wondering if there is a way to do the same kind of "dashboard' WITHOUT VBA ? Perhaps/probably I use VBA while it is not necessary.
* How could I dynamically change the pivot field (week or month) of the pivot table ?
* How could I dynamically update the chart too accordingly ?
Thank you for your ideas and experience