PowerPoint 2007 - animating charts imported from Excel

A

asgallant

I have a number of questions about animating charts in PowerPoint:

1. I can't seem to get PowerPoint to allow me to animate a graph by series
with one animation and category with another animation in the same slide. It
applies the same group style to the whole chart. Is there any way to work
around this without breaking up the slide into multiple slides and animating
each in a single group style?

Ex: Animating a combo Line/Column graph, animate the line with a "Wipe"
entrance while using a "Blink" emphasis on each column in sequence.

2. Some animation group styles are available for a given animation on some
charts, but not others. More specifically, it seems that the options are
available on charts where they are not needed, and a re unavailable on charts
where they would be most helpful - like animate "by element in category" (or
series) is available for the "Flash Bulb" animation in a Column chart but not
in a combo Line/Column chart. In the plain Column chart, animating "by
category" and "by element in category" work exactly the same, as near as I
can tell. In the combo chart, animate "by category" animates the column and
line segment for the data point with the same animation at the same time.
One would expect that animating "by element in category" (or series) would
animate only the column or line segment for a particular point, but the
option is unavailable. Is there any workaround for this?

3. Is there a method to animate only a single element within a chart,
without animating every element and then deleting all of the animations
except the desired one?

Ex. Animate a Column chart with 10 columns, and "Blink" only one of them
without applying the "Blink" animation to all of them and deleting the
animation for the other 9.

4. When animating "by category" can the animations be reordered without
setting up multiple animations and deleting select animations from each
sequence to arrive at the desired sequence? The "Re-Order" option is greyed
out for the elements within the default sequence for "by category" animations.

Ex. Animate a Column chart with the "Blink" animation in an out-of-order
sequence (say, category 4, 3, 6, 5, 2, 9, 8, 1, 10, 7).

5. I have a Bar chart with both positive and negative values where the
category axis overlaps the bars for negative values. If I animate the bars
with negative values, the layering on the chart changes, and they overlap the
category axis, covering the category titles. Is there a way to change the
layering of charts in PowerPoint? The "Bring Forward" and "Move Back"
options for both the bars and the axis are greyed out.

6. Why do the animations on a chart reset to the default if I make any
change to the chart aside from adding new animations? Is there a way around
this?

Ex. Animate a Column chart with 10 elements "by category" with the "Blink"
emphasis on one column, and then add the "Bevel" Shape Effect to the columns
- the animation will reset to using the "Blink" effect on each category in
sequence.

I know I can work around some of these by importing the charts as Enhanced
Metafiles and then ungrouping them, but the conversion to EMF alters the
appearance of the charts so they look noticeably different from the other
charts in the presentation. Any advice, hints, tips, tricks, or solace would
be appreciated.

- Andrew Gallant
 
E

Echo S

asgallant said:
I have a number of questions about animating charts in PowerPoint:

Hi, Andrew. I'll try to answer some of them.
1. I can't seem to get PowerPoint to allow me to animate a graph by
series
with one animation and category with another animation in the same slide.
It
applies the same group style to the whole chart. Is there any way to work
around this without breaking up the slide into multiple slides and
animating
each in a single group style?

Ex: Animating a combo Line/Column graph, animate the line with a "Wipe"
entrance while using a "Blink" emphasis on each column in sequence.

This is correct. I've tried expanding the animations, which allows you to
apply different animations with text. But it doesn't with charts. I think
ungrouping is your only option.

When I have to ungroup to animate charts, I copy the original and drag the
original off the side of the slide. I size it at 5% x 5% so it doesn't
interfere with my editing view. That way I have the original if needed. And
of course, I leave the animation until the last possible minute to minimize
changes.
2. Some animation group styles are available for a given animation on
some
charts, but not others. More specifically, it seems that the options are
available on charts where they are not needed, and a re unavailable on
charts
where they would be most helpful - like animate "by element in category"
(or
series) is available for the "Flash Bulb" animation in a Column chart but
not
in a combo Line/Column chart. In the plain Column chart, animating "by
category" and "by element in category" work exactly the same, as near as I
can tell. In the combo chart, animate "by category" animates the column
and
line segment for the data point with the same animation at the same time.
One would expect that animating "by element in category" (or series) would
animate only the column or line segment for a particular point, but the
option is unavailable. Is there any workaround for this?

The available animations depend on a combination of the type of chart and
the type of animation. More complicated animations usually cannot be applied
"by category" or "by series." There's no workaround that I'm aware -- other
than ungrouping.
3. Is there a method to animate only a single element within a chart,
without animating every element and then deleting all of the animations
except the desired one?

Ex. Animate a Column chart with 10 columns, and "Blink" only one of them
without applying the "Blink" animation to all of them and deleting the
animation for the other 9.

That's the only way I know to do it. Animate the chart, apply the "series"
or "category" animation (which applies to all series/categories), expand
contents of animation, remove animations as necessary.
4. When animating "by category" can the animations be reordered without
setting up multiple animations and deleting select animations from each
sequence to arrive at the desired sequence? The "Re-Order" option is
greyed
out for the elements within the default sequence for "by category"
animations.

Ex. Animate a Column chart with the "Blink" animation in an out-of-order
sequence (say, category 4, 3, 6, 5, 2, 9, 8, 1, 10, 7).

No, this isn't possible.
5. I have a Bar chart with both positive and negative values where the
category axis overlaps the bars for negative values. If I animate the
bars
with negative values, the layering on the chart changes, and they overlap
the
category axis, covering the category titles. Is there a way to change the
layering of charts in PowerPoint? The "Bring Forward" and "Move Back"
options for both the bars and the axis are greyed out.

Unfortunately, the only way I know to do this is also to ungroup.
6. Why do the animations on a chart reset to the default if I make any
change to the chart aside from adding new animations? Is there a way
around
this?

Ex. Animate a Column chart with 10 elements "by category" with the "Blink"
emphasis on one column, and then add the "Bevel" Shape Effect to the
columns
- the animation will reset to using the "Blink" effect on each category in
sequence.

Oh, wow, I hadn't noticed that. I'd say that's a bug.
I know I can work around some of these by importing the charts as Enhanced
Metafiles and then ungrouping them, but the conversion to EMF alters the
appearance of the charts so they look noticeably different from the other
charts in the presentation. Any advice, hints, tips, tricks, or solace
would
be appreciated.

Sorry, I don't really have any good tips for you, other than converting them
all to images so they look the same.
 
A

asgallant

*sigh* I was hoping someone knew some magic I was unaware of to get around
these annoyances. Oh well, I guess I'm stuck doing things the hard way. <;o(

Thanks anyway, Echo. At the very least I now know exactly what I'm up
against here.

- Andrew

BTW, anyone know how to report that bug to Microsoft?

Echo S said:
asgallant said:
I have a number of questions about animating charts in PowerPoint:

Hi, Andrew. I'll try to answer some of them.
1. I can't seem to get PowerPoint to allow me to animate a graph by
series
with one animation and category with another animation in the same slide.
It
applies the same group style to the whole chart. Is there any way to work
around this without breaking up the slide into multiple slides and
animating
each in a single group style?

Ex: Animating a combo Line/Column graph, animate the line with a "Wipe"
entrance while using a "Blink" emphasis on each column in sequence.

This is correct. I've tried expanding the animations, which allows you to
apply different animations with text. But it doesn't with charts. I think
ungrouping is your only option.

When I have to ungroup to animate charts, I copy the original and drag the
original off the side of the slide. I size it at 5% x 5% so it doesn't
interfere with my editing view. That way I have the original if needed. And
of course, I leave the animation until the last possible minute to minimize
changes.
2. Some animation group styles are available for a given animation on
some
charts, but not others. More specifically, it seems that the options are
available on charts where they are not needed, and a re unavailable on
charts
where they would be most helpful - like animate "by element in category"
(or
series) is available for the "Flash Bulb" animation in a Column chart but
not
in a combo Line/Column chart. In the plain Column chart, animating "by
category" and "by element in category" work exactly the same, as near as I
can tell. In the combo chart, animate "by category" animates the column
and
line segment for the data point with the same animation at the same time.
One would expect that animating "by element in category" (or series) would
animate only the column or line segment for a particular point, but the
option is unavailable. Is there any workaround for this?

The available animations depend on a combination of the type of chart and
the type of animation. More complicated animations usually cannot be applied
"by category" or "by series." There's no workaround that I'm aware -- other
than ungrouping.
3. Is there a method to animate only a single element within a chart,
without animating every element and then deleting all of the animations
except the desired one?

Ex. Animate a Column chart with 10 columns, and "Blink" only one of them
without applying the "Blink" animation to all of them and deleting the
animation for the other 9.

That's the only way I know to do it. Animate the chart, apply the "series"
or "category" animation (which applies to all series/categories), expand
contents of animation, remove animations as necessary.
4. When animating "by category" can the animations be reordered without
setting up multiple animations and deleting select animations from each
sequence to arrive at the desired sequence? The "Re-Order" option is
greyed
out for the elements within the default sequence for "by category"
animations.

Ex. Animate a Column chart with the "Blink" animation in an out-of-order
sequence (say, category 4, 3, 6, 5, 2, 9, 8, 1, 10, 7).

No, this isn't possible.
5. I have a Bar chart with both positive and negative values where the
category axis overlaps the bars for negative values. If I animate the
bars
with negative values, the layering on the chart changes, and they overlap
the
category axis, covering the category titles. Is there a way to change the
layering of charts in PowerPoint? The "Bring Forward" and "Move Back"
options for both the bars and the axis are greyed out.

Unfortunately, the only way I know to do this is also to ungroup.
6. Why do the animations on a chart reset to the default if I make any
change to the chart aside from adding new animations? Is there a way
around
this?

Ex. Animate a Column chart with 10 elements "by category" with the "Blink"
emphasis on one column, and then add the "Bevel" Shape Effect to the
columns
- the animation will reset to using the "Blink" effect on each category in
sequence.

Oh, wow, I hadn't noticed that. I'd say that's a bug.
I know I can work around some of these by importing the charts as Enhanced
Metafiles and then ungrouping them, but the conversion to EMF alters the
appearance of the charts so they look noticeably different from the other
charts in the presentation. Any advice, hints, tips, tricks, or solace
would
be appreciated.

Sorry, I don't really have any good tips for you, other than converting them
all to images so they look the same.

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

Echo S

I know. Sometimes all we can do is stop you banging your head against the
wall. 8-|

I'll report these issues to MS.

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


asgallant said:
*sigh* I was hoping someone knew some magic I was unaware of to get
around
these annoyances. Oh well, I guess I'm stuck doing things the hard way.
<;o(

Thanks anyway, Echo. At the very least I now know exactly what I'm up
against here.

- Andrew

BTW, anyone know how to report that bug to Microsoft?

Echo S said:
asgallant said:
I have a number of questions about animating charts in PowerPoint:

Hi, Andrew. I'll try to answer some of them.
1. I can't seem to get PowerPoint to allow me to animate a graph by
series
with one animation and category with another animation in the same
slide.
It
applies the same group style to the whole chart. Is there any way to
work
around this without breaking up the slide into multiple slides and
animating
each in a single group style?

Ex: Animating a combo Line/Column graph, animate the line with a "Wipe"
entrance while using a "Blink" emphasis on each column in sequence.

This is correct. I've tried expanding the animations, which allows you to
apply different animations with text. But it doesn't with charts. I think
ungrouping is your only option.

When I have to ungroup to animate charts, I copy the original and drag
the
original off the side of the slide. I size it at 5% x 5% so it doesn't
interfere with my editing view. That way I have the original if needed.
And
of course, I leave the animation until the last possible minute to
minimize
changes.
2. Some animation group styles are available for a given animation on
some
charts, but not others. More specifically, it seems that the options
are
available on charts where they are not needed, and a re unavailable on
charts
where they would be most helpful - like animate "by element in
category"
(or
series) is available for the "Flash Bulb" animation in a Column chart
but
not
in a combo Line/Column chart. In the plain Column chart, animating "by
category" and "by element in category" work exactly the same, as near
as I
can tell. In the combo chart, animate "by category" animates the
column
and
line segment for the data point with the same animation at the same
time.
One would expect that animating "by element in category" (or series)
would
animate only the column or line segment for a particular point, but the
option is unavailable. Is there any workaround for this?

The available animations depend on a combination of the type of chart and
the type of animation. More complicated animations usually cannot be
applied
"by category" or "by series." There's no workaround that I'm aware --
other
than ungrouping.
3. Is there a method to animate only a single element within a chart,
without animating every element and then deleting all of the animations
except the desired one?

Ex. Animate a Column chart with 10 columns, and "Blink" only one of
them
without applying the "Blink" animation to all of them and deleting the
animation for the other 9.

That's the only way I know to do it. Animate the chart, apply the
"series"
or "category" animation (which applies to all series/categories), expand
contents of animation, remove animations as necessary.
4. When animating "by category" can the animations be reordered
without
setting up multiple animations and deleting select animations from each
sequence to arrive at the desired sequence? The "Re-Order" option is
greyed
out for the elements within the default sequence for "by category"
animations.

Ex. Animate a Column chart with the "Blink" animation in an
out-of-order
sequence (say, category 4, 3, 6, 5, 2, 9, 8, 1, 10, 7).

No, this isn't possible.
5. I have a Bar chart with both positive and negative values where the
category axis overlaps the bars for negative values. If I animate the
bars
with negative values, the layering on the chart changes, and they
overlap
the
category axis, covering the category titles. Is there a way to change
the
layering of charts in PowerPoint? The "Bring Forward" and "Move Back"
options for both the bars and the axis are greyed out.

Unfortunately, the only way I know to do this is also to ungroup.
6. Why do the animations on a chart reset to the default if I make any
change to the chart aside from adding new animations? Is there a way
around
this?

Ex. Animate a Column chart with 10 elements "by category" with the
"Blink"
emphasis on one column, and then add the "Bevel" Shape Effect to the
columns
- the animation will reset to using the "Blink" effect on each category
in
sequence.

Oh, wow, I hadn't noticed that. I'd say that's a bug.
I know I can work around some of these by importing the charts as
Enhanced
Metafiles and then ungrouping them, but the conversion to EMF alters
the
appearance of the charts so they look noticeably different from the
other
charts in the presentation. Any advice, hints, tips, tricks, or solace
would
be appreciated.

Sorry, I don't really have any good tips for you, other than converting
them
all to images so they look the same.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top