I have a table aswel as a chart but I cannot seem to work out how to add various/ different targets. I have 5 KPIs and each of them have a different target. I would like another column beside the existing percentages showing me the targets for each KPI and also to RAG if they hit their target. packaged workbook added 10.3.
Thank you in advance.
6 answers
Hi Mubasher,
Here you go! I made up the goals, but you should be able to edit those values as you please to get your desired results.
