Forum Discussion
What type of chart please
Hi guys, I am looking some help. Can anyone advise on what type of chart is needed (if at all possible) to present the below set of data exactly in the way I have created the below mockup.
I have tried various bar/cluster/waterfalls, etc but I cannot get the data to be in the same axis format as below.
Thanks
Clarke
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.
2 Replies
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.
