Bubble Charts in PowerPoint 2007

[Ashley]

I am trying to create a bubble chart design template that I can apply to
multple slides. I am able to get this concept to work with bar charts, etc,
but am having trouble with the bubble charts. I can create and save the
templates fine. I will then add a new slide and apply the design template.
Once I try to import new data from an exsiting excel spreadsheet (it is
already in the correct format). Nothing appears on my chart area. I have
checked and the scales are not changing.

I can copy and paste the same data into a bubble chart when I create a new
chart without applying a template and there are no problems.

Can anyone help?

Thanks

 

[Pia Bork]

I am trying to create a bubble chart design template that I can apply
to multple slides. I am able to get this concept to work with bar
charts, etc, but am having trouble with the bubble charts. I can
create and save the templates fine. I will then add a new slide and
apply the design template. Once I try to import new data from an
exsiting excel spreadsheet (it is already in the correct format).
Nothing appears on my chart area. I have checked and the scales are
not changing.

Ashley, it seems as if the template of the bubble chart comes along with a
wrong data area in Excel. For me it works this way:
- insert a new slide and a make a new bubble chart on it (no using your
template yet)
- copy the data from the existing excel sheet into the data area for the
bubble chart
- apply your template with "Change Chart Type/Template"




--
Mit lieben Grüßen
Pia Bork
MVP Powerpoint
http://www.ppt-faq.de
http://www.office-training-muenchen.de

 

[Ashley]

Thank you very much for the tip! Unfortunately, when I go to change the
template, once the template it applied, all of the data disappears from my
chart area. Could there be any reason why this is happening? ( it is the same
data I used to create the chart in the first place and it worked without
problem)

 

[Pia Bork]

Thank you very much for the tip! Unfortunately, when I go to change
the template, once the template it applied, all of the data
disappears from my chart area. Could there be any reason why this is
happening? ( it is the same data I used to create the chart in the
first place and it worked without problem)

I played around with the "bubbles" and I'm puzzled...

- First I made a new bubble chart. The data in Excel have the columns
X-Values, Y-Values and Size, the rows have no labels in front of the
numbers.
- I saved this chart in Powerpoint as a template.
- Now I make a new slide with a new chart and choose "Insert Charts /
Templates / MyBubbles". Excel opens and has changed in a very strange way:
the columns are now Series 1, Series 2 and Series 3; the rows are Category 1
to Category 4. The template didn't store X-Values, Y-Values and Size.

On this basis there cannot be made a bubble chart! So my chart is empty as
yours.


What works for me is this way to apply my bubble-template:
- I make a new slide with a chart and do not choose my bubble-template in
the first place but the bubble-chart Powerpoint offers
- Afterwards I went to "Chart tools / Type / Change Chart Type" and applied
my bubble-template. Now it's ok.


Do you see the same odd behaviour?


--
Mit lieben Grüßen
Pia Bork
MVP Powerpoint
http://www.ppt-faq.de
http://www.office-training-muenchen.de

 

[Ashley]

I too found the same odd behavior. However, when I followed your method of
"Chart tools / Type / Change Chart Type" and applying my design template, all
of the data disappears! The only thing my design template is applying is font
size, type, bubble color and scale - so i'm not sure why the data is being
cleared off when I attempt to apply the template.

 

[Echo S]

I think the issue is that chart templates don't hold data. This is by design
(a design I hope they change in future).

So I believe you must apply the existing bubble chart to get the data, then
apply your own chart template to get the look.

 

[signy]

Creating these charts can take a lot of time. I've created a template
taht makes it easier to quickly create multiple charts with multiple
series

http://excel-bubble-charts.blogspot.com/