Combining Radar and Bubble charts
 

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?
--
Gerry

Combining Radar and Bubble charts
 

On Thu, 12 Jul 2007, in microsoft.public.excel.charting,
Gerry said:

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.


--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Combining Radar and Bubble charts
 

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?

--
Thanks,
Shane Devenshire


"Gerry" wrote:

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?
--
Gerry

Combining Radar and Bubble charts
 

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.

--
Cheers,
Shane Devenshire


"Gerry" wrote:

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?
--
Gerry

Combining Radar and Bubble charts
 

Use custom-sized markers in your radar chart:

http://peltiertech.com/Excel/ChartsH...omMarkers.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gerry" wrote in message
...
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?
--
Gerry

Combining Radar and Bubble charts
 

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?
--
Gerry


"Jon Peltier" wrote:

Use custom-sized markers in your radar chart:

http://peltiertech.com/Excel/ChartsH...omMarkers.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gerry" wrote in message
...
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?
--
Gerry

Combining Radar and Bubble charts
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gerry" wrote in message
...
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?
--
Gerry


"Jon Peltier" wrote:

Use custom-sized markers in your radar chart:

http://peltiertech.com/Excel/ChartsH...omMarkers.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gerry" wrote in message
...
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?
--
Gerry