Hi all. This is my first post I hope someone can help. I am creating a dashboard at the moment, meant for multiple users ranging in excel experience levels. There are various background tables feeding this; one of which contains 25 years worth of comparative pricing data for two products. Where I am stuck is that I would like to create a table that will allow the users to select a start and end date and automatically populate a line graph with the data for that date range. I am happy with the use of Formula however VBA is new to me so may need assistance if that is required. Hopefully there is help at hand
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Populating a table with ranges specified in cells
- Thread starter Dannyss
- Start date
cyrilbrd
Well-known Member
- Joined
- Feb 2, 2012
- Messages
- 4,113
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi, wouldn't a pivot table work for this?
if you need a dynamic chart you just need to create a table that will fetch the data from the specific period of time, any change will be resulted in a chart change equivalent to the data... right? What part holds difficulties?
if you need a dynamic chart you just need to create a table that will fetch the data from the specific period of time, any change will be resulted in a chart change equivalent to the data... right? What part holds difficulties?
Upvote
0
Similar threads
- Solved
