One may want to create interactive graphs by allowing users to select indicators and years to be plotted (via check boxes and scroll bars). I have presented three cases in this workbook.
Hello
This post was helpful but i have a different query.
I need to be able to plot a new chart by selecting Variables from a drop-down menu for the Y-axis.
There have to be two buttons.
1. For adding Plots similar to the one above on the present sheet.
2. Generate plot button which will generate all the plots selected above in new worksheets.
I think i need to use macros for this.
Any advice would be really helpful.
Thank you for your prompt reply.
-
Hi,
Upload your workbook to OneDrive and share the link of the workbook here. Please clarify what plots do you exactly want. Your second question for now is not important because that would arise only one the first question is resolved.
Control graphs with check boxes and scroll bars
{ 2 Comments }