Hello
I have 3 radio buttons - revenue, volume1 and volume2 - and one combo box for client name. The user selects a client from the filter and then selects one of the 3 radio buttons to view the corresponding graph. The graphs are based on 3 different pivot tables on 3 separate worksheets. the entire setup is working fine using macros/vba. however i am struggling with the chart titles. When the user selects a client name A and then selects say revenue then he sees teh relevant graph and correct chart title. however if he now selects say client B from drop down leaving revenue selected then the data on the chart gets updated for client B however the title still says client A. the user has to click on one of the other radio buttons to refresh the title. is there any way i can have the title refresh at the time of the client selection no matter what radio button is clicked on?
I hope the above makes sense, please let me know if any more info is needed
thanks!
I have 3 radio buttons - revenue, volume1 and volume2 - and one combo box for client name. The user selects a client from the filter and then selects one of the 3 radio buttons to view the corresponding graph. The graphs are based on 3 different pivot tables on 3 separate worksheets. the entire setup is working fine using macros/vba. however i am struggling with the chart titles. When the user selects a client name A and then selects say revenue then he sees teh relevant graph and correct chart title. however if he now selects say client B from drop down leaving revenue selected then the data on the chart gets updated for client B however the title still says client A. the user has to click on one of the other radio buttons to refresh the title. is there any way i can have the title refresh at the time of the client selection no matter what radio button is clicked on?
I hope the above makes sense, please let me know if any more info is needed
thanks!