bubble charts (again)

J

Josie

When using a bubble chart, I've been using 'width' as the
thrid value, rather then area, via the 'Size represents'
frame.

Is there any way, however, to make the units in which
you've specified the bubble width the same as the units on
the axes? At the moment, bubbles within a chart are the
right size in relation to each other, but bubbles on
different charts are not.
 
J

Jon Peltier

Josie -

This would be rather a difficult, albeit tedious, task. You would have to first make
sure the axis sizes and scales of the multiple charts all matched up.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bubble Sizes in Bubble Chart 1
pie charts instead of bubbles 3
Making a Bubble Chart with 4 variables instead of 3 1
Bubble Charts 3
Problem with BUBBLE CHART scale and legend 6
displaying hidden/smaller bubbles on a bubble chart 1
How do i "bring to front" bubbles in excel bubble charts which ar. 1
Bubble chart basics 2

Top