5 variable bubble chart?

[bkavlakov]

Hmm... I could not find much discussion about bubble
charts on these pages, but I have been amazed by the
creativity of this group, so I decided to post my problem.

Problem:
I need to make a bubble chart in which EACH bubble will
have an arrow attached to it, indicating a direction of
movement. I envision that this could be done by a regular
bubble chart (3 variables) + some line chart? which will
duplicate the XY vaariables from the bubble and use two
more variables for X2 and Y2.

I would be very greatful if anyone has any tips about
this or something similar. Thanks in advance.

-Boris

 

[Jon Peltier]

Boris -

This isn't a bubble chart, but it can do what you want. It draws an
arrow (just a straight line arrow, but you could use one of the
autoshape block arrows), lengthens it according to some variable (say,
velocity), rotates it according to some angle (wind direction?), then
places it at X,Y on a scatter chart. You could even adjust the color
for an additional variable (temperature). It's also not too heavily
documented.

http://www.geocities.com/jonpeltier/Excel/Zips/VectorChart.zip

- Jon