Combining Radar and Bubble charts

[Gerry]

I want to display data on a radar chart using bubbles but can't figure out
how to do this in excel. Is it possible or is other software needed, if so,
any suggestions?

 

[Del Cotter]

I want to display data on a radar chart using bubbles but can't figure out
how to do this in excel. Is it possible or is other software needed, if so,
any suggestions?

Bubble charts won't combine with anything else, so you'll have to
somehow draw the lines yourself using trigonometry. Line charts and
scatter charts are also out, so I don't know how you'll draw the lines.

There is just one radar chart I can seehow you could mimic, and that
would be one with four arms. You could use the axes for that.

Alternatively, make guide bubbles, and use drawing tools to manually
draw lines where the bubbles go. Then make the bubbles invisible.

 

[ShaneDevenshire]

Hi,

It's not clear to me what you want - do you want a chart made of two chart,
a radar and a bubble or do you mean that you want some points on the radar
chart to be bubbles rather than points? And if so would you be happy with
all the points being the same size bubbles?

 

[ShaneDevenshire]

Hi,

Here is a method if you are willing to have all the bubbles the same size:

1. Create a bubble or ball in the spreadsheet using any graphic tools you
want. I inserted a charactor from the Wingdings font set and then changes
its size to 22.
2. Turn off the gridlines - Tools, Options, View, Gridlines.
3. Select the cell containing the graphic.
4. Hold down the Shift key and choose Edit, Copy Picture, OK.
5. Select the data series on the radar chart and choose Paste.

 

[Jon Peltier]

Use custom-sized markers in your radar chart:

http://peltiertech.com/Excel/ChartsHowTo/CustomMarkers.html

- Jon

 

[Gerry]

Jon,

Thanks for the suggestion however, I am struggling to figure out how to size
the custom markers according to each data point value - any suggestions?

 

[Jon Peltier]

You need to come up with a relationship between the value and the dimensions
of the graphic object. Then you can right click the graphic, choose Format,
adjust the size on the Size tab, then copy it and paste it onto the data
point. Or use a macro to size it for you...

- Jon