I have a spread sheet with multiple tabs that consist of charts displaying tables of data. I currently have three specific charts. One tracks performance of a sector of the company based on sales figures. The next chart tracks a given division within that sector and compares day by day performance this month to day by day performance last month. I have two of these comparison charts, one for each division within my sector.
What I'd like to do is have a single spreadsheet, or 'front end' if you will, where a user can open the spreadsheet and select from a drop down box which chart they'd like to view and upon selecting which they'd like to view the graph on the sheet will populate with the selected data. I also should note that it will require one chart to be a line graph and the other two to be bar graphs.
How would I go about making this happen.
thank you in advance for any help.
@fifthmanstanding -
This is very easy to do if you incorporate named ranges. If you aren't sure how to use them look them up on Google. If you are still having issues, upload a sample .xlsx with the layout you're looking for, and some dummy data.
If you my posts help you, click the star icon!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks