Brian Robinson
New Member
This post could fit in Dashboards, Charts or VBA, but since I am at a stopping point on how to use VBA for controls, I posted here.
I am an intermediate Excel user and have made a good attempt at achieving my desired design for the problem below, but I'm stuck at this point and not sure if there is a better way??
I have attached a file which documents my problem. There is an Orange Fill text box on the Dashboard page which explains what I'm trying to accomplish. I just need to get one chart working and then will replicate across entire dashboard.
Basically, I want to allow user to select the following:
1) Show in Dollars or Units (I have this working)
2) Show by Consolidated Total or by All Categories (this is partially working)
3) Use the slicers to control location view (this works fine)
#2 is where I don't know how to complete all of the functionality as described in the text box on Dashboard sheet. Do I have to switch to Active X controls and program each control with VBA to do what I want it to do???
Just not sure where to go from here. Any help / pointers is greatly appreciated.
I am an intermediate Excel user and have made a good attempt at achieving my desired design for the problem below, but I'm stuck at this point and not sure if there is a better way??
I have attached a file which documents my problem. There is an Orange Fill text box on the Dashboard page which explains what I'm trying to accomplish. I just need to get one chart working and then will replicate across entire dashboard.
Basically, I want to allow user to select the following:
1) Show in Dollars or Units (I have this working)
2) Show by Consolidated Total or by All Categories (this is partially working)
3) Use the slicers to control location view (this works fine)
#2 is where I don't know how to complete all of the functionality as described in the text box on Dashboard sheet. Do I have to switch to Active X controls and program each control with VBA to do what I want it to do???
Just not sure where to go from here. Any help / pointers is greatly appreciated.