PPT, how to create multiple Buble charts using one linked legend

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i would like to place four alike Buble chart using the same criterias,
different data, but linked to the same legend.

If I need to change a color of a bubble it would like to all the bubbles and
the ledgend.

Is this possible, or do I need to create the legend manually?
 
For the first part, you could just keep the legend of one chart. For the
second part, you'll have to do three of the charts manually if you change the
legend color.

There isn't a way to tie a single legend to four different charts.
 
Molly,
Actually, there is a way to make multiple charts on a single chart
sheet in Excel and one of the chart types would be with a Legend. The
others without a Legend.

To get the colors of all same data points to update to a new color,
you could do this with VBA or you could do it manually by changing the
color palette in Excel under Tools + Options + Colors.

And Glenna, don't be embarassed that you diidn't know how to do it. I
was flat out told by my 3 favorite programmers including someone who
concentrates primarily in Excel at a very very high level that this
could just not be done. Minutes later they had a sample in their
mailboxes.

The basic steps for creating multiple charts on a single chart sheet
are to create a chart on a chart sheet from a blank cell of data. You
won't see anything but the blank chart sheet.

Next create the actual charts and change the Location in the Chart
Wizard to point at that blank chart sheet as the location to put the
charts.

Now all you have to do is to size each chart object on the blank chart
sheet to meet your design requirements.

There are three other sources of information on this if you do a
little digging. Jon Peltier's web site, John Walkenbach's book on
charting in Excel. Jon also posted some sample VBA code in the Excel
Charting Newsgroup that can be modified to meet your needs if you know
any VBA. In any case it can be done and it can be done manually too.

Brian Reilly, MVP
 
And Glenna, don't be embarassed that you diidn't know how to do it.

ROFL! I save embarassed for when I really stick my foot in my mouth. Not
knowing how to do a fancy work-around like this puppy doesn't qualify. But
thanks for teaching an old dog a new trick!
 
Glenna,
This is not a work-around. It is natively there, just not obvious (g).
And since you grew up on a mountain and the legs are different lengths
no matter how much you pull on them it must be quite humorous to see
you put your foot in your mouth. A true test of foot-eye coordination.
You are too funny young lady. Regards.

Brian Reilly, MVP
 
Back
Top