• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Controls for Charts

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.
 

Attachments

  • Chart with multiple controls.xlsx
    268.5 KB · Views: 8
Back
Top