Need code written or excel magic so graphs generated from data will change with date input

• Status: Closed
• Prize: $50
• Entries Received: 2
• Winner: lherreraz

Winner

Contest Brief

Have an excel sheet with graphs currently set up pulling information from tables. The weekly graphs need to be set up so they automatically show the last 12 weeks of data (12 weeks back from the the date input) and the monthly graphs need to be set up so they automatically update to show the last 12 months of data based on the date input.

There needs to be a way to enter the date so that the graphs know were to work back from? Maybe a pop up textbox in vba asking for the date? or a box in excel where the date is entered?

Feel free to change the graphs and tables as need be to any format or setup to make this possible. The easier the sheet is to use the more likely it will be to win.

Will need to see a video or some evidence of the graphs working with changing date to award this prize.

If this an exceptionally hard task or requires significant work please let me know

Recommended Skills

• Data Processing
• Engineering
• Excel Macros
• Excel VBA
• Visual Basic