rick robin
New Member
i am trying to create a dynamic dashboard but have come stuck with automating excel shapes and pie chart to work in sync. i have tried various methods but to no avail/none work smoothly.
please can someone help.
what i am trying to do is:
(1) Based on an excel table with data - if the value in the cell is > 0 the upper arrow becomes visible or change from no fill to green - if the value is < 0 then down arrow change from no fill to red - if zero then remain no fill (invisible). i need this to update every time the cell changes.
(2) simultaneously depending on which values in the table changing the pie chart would update but hide the series that are not changing.
(3) an additional feature which i do nt know whether possible is if a slicer could be used so the user can select a particular series and just view that piece of the pie chart info instead of the full pie chart.
I have attached the WIP dashboard with the pie chart and up/down arrows i am working with.
Any help/advice would be appreciated.
Many thanks
please can someone help.
what i am trying to do is:
(1) Based on an excel table with data - if the value in the cell is > 0 the upper arrow becomes visible or change from no fill to green - if the value is < 0 then down arrow change from no fill to red - if zero then remain no fill (invisible). i need this to update every time the cell changes.
(2) simultaneously depending on which values in the table changing the pie chart would update but hide the series that are not changing.
(3) an additional feature which i do nt know whether possible is if a slicer could be used so the user can select a particular series and just view that piece of the pie chart info instead of the full pie chart.
I have attached the WIP dashboard with the pie chart and up/down arrows i am working with.
Any help/advice would be appreciated.
Many thanks