Good morning everybody,

Here's the issue (see file enclosed to understand). I have an excel sheet with +- 1000 lines of data regarding specific projects I need to individually assess. The columns comprise raw data over each project (name, actor etc.) as well as the results of the assessment (quotation, ratios, Go No-go etc.)

Rather than making a powerpoint every week on the hundreds of projects I have to present (implying notably to copy/paste the evaluation of every project in the form of a radar-chart), I would prefere to save time by having a good-looking and handy excel dashboard.

I think I can handle 75% of the data I want to see appear on the dashboard via vlookups. 2 issues remain (but you might find more):
- How do I change the project code in cell C2 very quickly (via button) to the next project? I need the possibility to come back to a previous one (I do not want to have this handled via dropdown list!)
- Probably more tricky: how do I get the radar-chart to automatically adjust to the next project without any manual handling (if possible)?

Thanks a lot for any little help you can give me on this guys!

HVBA dashboard example.xls