happy_smiler1
New member
- Joined
- Aug 28, 2012
- Messages
- 67
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- office 365
hi all,
Is there a way in excel 2007 to create one graph that shows vol as a bar graph and the second as a line graph showing val but when the user clicks a button for vol it sbows the bar graph and if the val is clicked then the line graph is showing but not at the same time as i know you can change the graph to primary or secondary?
i could have two seperate graphs overlapping but how would i get the interaction between vol and val to work?
Any ideas or guidance would be greatly appreciated.
Thanks.
Is there a way in excel 2007 to create one graph that shows vol as a bar graph and the second as a line graph showing val but when the user clicks a button for vol it sbows the bar graph and if the val is clicked then the line graph is showing but not at the same time as i know you can change the graph to primary or secondary?
i could have two seperate graphs overlapping but how would i get the interaction between vol and val to work?
Any ideas or guidance would be greatly appreciated.
Thanks.