View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default Bubble chart basics

On Tue, 18 Sep 2007, in microsoft.public.excel.charting,
LauriS said:
Using 2000 I am trying to come up with a meaningful sample of a bubble chart
for the charting class I teach and I'm having a really tough time.


If I put the data label values on the series I get the region names - but
I'm thinking they should be part of the bottom axis.


The X axis in a bubble chart is an interval axis, as in a scatter chart,
not a category axis, as in a bar chart.

The only way to get the region names where you want them will be to
create a dummy bubble series, give the bubbles the region names as data
labels, then format the bubbles to be invisible. Which is probably not a
set of operations you want to have to explain to your class.

--
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.