Hi all,

First time question here, I have been tasked with creating a number of bubble charts which take a long time and I was hoping there might be a way of automating some of this process.

Essentially I have the attached bubble graph which I am trying to create but for each chart need to create the matrix on the side. I think this is because bubble graphs require numerical data on the x and y axis and I am using categories. At the moment I also have to manually build each chart (adding a series in at a time) and then manually add in the text box labels. I'm just wondering if there is a simpler way to do this?

I've done some research (googled!) and think they may be called matrix charts?

Any help on this would be very appreciated!

Thanks

example.xlsx