Forum Discussion
What type of chart please
There is no option for that exactly. The best you can do is create 3 bar charts:
and I will leave up to you to add the additional lines and labels (you can configure those charts to not show the x and y labels and then you can Insert bold lines to simulate the x and y axes and a text box for the KBI labels)
PS - sry I didn't notice you included the table of actual values so I was guessing when I created mine. That said you may also need/want to format the x-axis and horizontal width of each to make sure the bars are scaled correctly reletive to each other.
There is no option for that exactly. The best you can do is create 3 bar charts:
and I will leave up to you to add the additional lines and labels (you can configure those charts to not show the x and y labels and then you can Insert bold lines to simulate the x and y axes and a text box for the KBI labels)
PS - sry I didn't notice you included the table of actual values so I was guessing when I created mine. That said you may also need/want to format the x-axis and horizontal width of each to make sure the bars are scaled correctly reletive to each other.
Thanks for the reply, I will do as you suggested as I didn't think there was a chart readily available to produce exactly what I needed. Thanks for the help.
