Transfer selective data from master table to a dashboard (don’t want pivots)
Say I have a table A2:H8 (SourceTable) in my source sheet, as shown in my screenshot_1.
How to create dynamic chart in Excel?
I’m creating a dashboard using EXCEL, and I have a graph that I present revenue by month year
(I present the growth in percentages) and I want to ass a button to switch this data range dashboard to present revenue in numbers also.
My data range is like this –