Changing legend for Excel Bubble chart 1

[GlennUK]

I'm stuck, I have a bubble chart which is working correctly, but the legend is showing the values from the X-values series instead of the Name series.

How do I get Excel to put the values from the Name series in the Legend?

Glenn.

 

[karengarrette]

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.

 

[GlennUK]

No, that doesn't work for bubble charts.

Glenn.

 

[xlhelp]

Hi, Glenn!

You may want to look at Rob Bovey's chart labeler at

http://www.appspro.com/downloads/XYChartLabeler.exe

HTH

Indu

 

[GlennUK]

Thanks,

I will right away.

Glenn.

 

[GlennUK]

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.

I guess that'll have to do.

Glenn.

 

[joannef]

Thanks Glenn,

That gave me a workaround as well.

Joanne

 

[GlennUK]

Hi Joanne,

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.

Glenn.