Jon, suitability of a bubble chart aside: how can I even show 4 years of
sales $, margin $ and Margin $ on the same bubble chart?

"Jon Peltier" wrote:

The data can be displayed on a bubble chart. However, one of the harder
things for people to do is correlate the size of a bubble with a value. A
combination bar-line or a line on two axes chart is a better choice.

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


"KG" wrote in message
...
A colleague of mine was asking me to use a bubble chart to show the
following
data for 2004, 2005, 2006 and 2007:

Sales Dollars
Margin Dollars
Margin as % of sales

I couldn't think of a way to display all these data on a bubble chart and
recommended a combination bar/line chart instead, with the margin % shown
as
a line with its own Y2 axis.

Was I wrong and can the above data set be displayed on a bubble chart
after
all?