Hello Mynda and all other Excel artists,
I have a question I would like to build a chart as described here.
However, I also need the dimension of the quarter, as I have a different targets and actuals for each quarter.
Can I map all this in one chart or do I need several charts?
Thank you very much. I have also copied in my data to give you better understanding.
Best regards and thanks,
Alex
| Q1 21 | Q2 21 | Q3 21 | Q4 21 | ||
| Tom | Target (KPI) | 14 | 17 | 22 | 27 |
| Forecast | 13 | 16 | 21 | 26 | |
| Actual | 11 | 14 | 19 | 24 | |
| Peter | Target (KPI) | 16 | 19 | 24 | 29 |
| Forecast | 18 | 21 | 26 | 31 | |
| Actual | 15 | 18 | 23 | 28 | |
| Paul | Target (KPI) | 20 | 23 | 28 | 33 |
| Forecast | 18 | 21 | 26 | 31 | |
| Actual | 16 | 19 | 24 | 29 | |
| Mary | Target (KPI) | 9 | 12 | 17 | 22 |
| Forecast | 16 | 19 | 24 | 29 | |
| Actual | 13 | 16 | 21 | 26 | |
| John | Target (KPI) | 11 | 14 | 19 | 24 |
| Forecast | 7 | 10 | 15 | 20 | |
| Actual | 5 | 8 | 13 | 18 | |
Hi Alex,
Yes, you can do it with this data but you need to change the layout of the table so that the first column is the name, the second column contains the quarters and then you have a column for Target, Forecast and Actual. You can use Power Query to unpivot the data and then pivot it for the 3 value columns. This is more in line with the layout in the file used in my video.
Mynda
Thank you!
