Charts with Option Buttons

[Excel-Access]

Hello Community

I have attached a chart template and I am struggling to modify it to what I want

I have highlighted in Yellow what my requirements are.

The Option button should have Sept. 2015, Oct. 2015 and Nov. 2015

Vertical Axis will be £ in millions

Horizontal Axis will be Category which will show BS, P&L and Run Rates

So when I click on the button Sept. 2015, I will see the value for BS, P&L and Run Rates

Can someone kindly assist me?

Thanks

 

[bobhc]

You could achieve this by just running and recording a macro.

 

[Excel-Access]

Hi, would be possible for you to kindly show me how - my knowledge of macro is limited?

Thanks

 

[Nebu]

Hi:

You do not need a macro to do this , find the attached.

Thanks

 

[sawtide]

Super Nebu

 

[Excel-Access]

Hi Nebu

I would like to thank you so much for your help.

I have a follow up question, I would like on the same worksheet to insert another chart fpr a different area. I am finding that once I create another chart and modify the links, if I then on the 2nd chart select Sept. 2015 I get #Ref Error and cell N1 changes to 4, October will be 5 etc.

How can I can incorporate two or three charts and make each chart work independently?

Thanks buddy

 

[Nebu]

Hi:

if you want to control each chart independently you will have to have separate option buttons. If you can upload a sample file I will be able to help you, but I would suggest to go through the file I had uploaded to understand the functionality better and try to do it yourself.

Thanks