| Goal Name | Metric | Original Target | Revised Target | 2023 Q1 | 2023 Q2 | 2023 Q3 | 2023 Q4 | 2024 Q1 |
| Goal 1 | Metric 1 | 50 | 100 | 70 | 80 | 95 | 110 | … |
| Goal 1 | Metric 2 | 5 | 6 | 1 | 2 | 4 | 7 | … |
| Goal 1 | Metric 3 | 10,000 | 15,000 | 5,000 | 7,000 | 11,000 | 14,000 | … |
| … | … | … | … | … | … | … | … | … |
Very simplified data structure above, basically I need to visualise alot of metrics across several goals/themes. The stakeholder wants to see actuals vs target (there's 2 targets) - my initial idea was to use a bullet chart but the problem I have is that the range of values differ quite alot across different metrics. The Microsoft Bullet Chart automatically scales the value axis to accomadate for this but the formatting options are very limited and visually looks quite boring - are there any other options?
Would it be more appropriate to convert my measures to progress as a % so the axis are the same? The stakeholder wants to see the actual values as well so I guess I could utilise tooltips here somehow? Open to ideas - (including custom visuals, deneb, charticulator...) but ideally out of the box functionality to keep future maintenance to a minimum. Thanks in advance, let me know if you need more information about the data structure etc.
