This seems to simple so this is probably not what you want, but here goes! Display your charting toolbar, and on it you have two buttons, one to display by columns and one by rows, that will switch them around.
Oh well, Rob Bovey's chart labeller doesn't do legends, but adds a label to each point of a series ( I already have a utility to do this ).
My workaround was to add a legend, and then suppress the text by making the font white-on-white, then add a text box with the correct labels and line it up with the legend symbols.
you'll never guess, I was playing with this yesterday and found that if I made each data point in the bubble graph a separate series, then the legend does what I want!
This was found by accident, I'd have never tried it otherwise.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.