Bubble Charts in PowerPoint 2007

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
Tue May 06 23:08:46 PDT 2008

Ashley wrote:
> 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
Wed May 07 07:14:03 PDT 2008

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" wrote:

> Ashley wrote:
> > 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
>
>
>

Pia
Wed May 07 11:33:21 PDT 2008

Ashley wrote:
> 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
Wed May 07 12:24:15 PDT 2008

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.



"Pia Bork" wrote:

> Ashley wrote:
> > 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
>
>
>

Echo
Wed May 07 16:16:48 PDT 2008

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.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


"Ashley" <Ashley@discussions.microsoft.com> wrote in message
news:488EA11B-D762-425D-8D6A-651C9E35E02F@microsoft.com...
>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.
>
>
>
> "Pia Bork" wrote:
>
>> Ashley wrote:
>> > 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
>>
>>
>>