Excel linked charts in Powerpoint reverts to a single chart


B

Bonji

I'm using office 2007 and I linked excel charts (about 8 and all in one excel
tab) into different slides in Powerpoint. After a few minutes, all the
information on the powerpoint charts would revert or change to a single chart
in the excel tab. It appears to me that when I copy and link the excel charts
into ppt, the link address in ppt points to one single chart in excel and not
the others. This started happening since I switched to office 2007. Any ideas
on resolving this issue?????

My alternative is to copy and past as picture but I have about 50 different
charts with the underlying data constantly changing.
 
Ad

Advertisements

E

Echo S

What if you move each chart to its own chart sheet in the Excel file? (You
can do that with a right-click -- right-click, Move Chart.)
 
B

Bonji

I created one chart, copied the chart onto different cell within same tab and
changed the data link or pointers.

I just noticed that, the chart names of the charts I copied did not change
or rather remains the same as original file. Could this be the major issue?
How can i change the chart name?

Bonji
 
B

Bonji

Thanks a lot for follow up. Let me start over....
1) I created a bar chart in a worksheet (chart A)
2) I made copies (about 8) of the same bar chart within the same worksheet
3) I changed the underlying data set used by each chart
4) I copied and paste/link each chart onto nine different slides within the
same Powerpoint file.
5) A few seconds later, i noticed that all the charts in the powerpoint
changed back to the chart A

I found that each chart within Excel has the same chart name (i.e. Chart 1)
looking at the top left corner of the excel worksheet. I changed the names of
each chart and recopied it into Powerpoint file. And my problem was solved.

I do agree that creating the charts in different worksheets would also
resolve my problems.

Thank you for your time!

Bonji



Echo S said:
I still think that putting the charts on separate chart sheets might help.

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


Steve Rindsberg said:
We really need more specific detail than that. Imagine that your mom's on
the other
end of the phone, knows nothing about Excel or PPT and you have to get her
to do the
job for you. And remember: Suicide is not an option. ;-)

So you created a chart in Excel?

You copied it onto a different cell within the same tab ... by tab, do you
mean
"Worksheet"?

Data link, pointers? What exactly did you do?



==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/

.
 
Ad

Advertisements

E

Echo S

Glad to hear you got it resolved. Thanks for posting back with your
solution.

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


Bonji said:
Thanks a lot for follow up. Let me start over....
1) I created a bar chart in a worksheet (chart A)
2) I made copies (about 8) of the same bar chart within the same worksheet
3) I changed the underlying data set used by each chart
4) I copied and paste/link each chart onto nine different slides within
the
same Powerpoint file.
5) A few seconds later, i noticed that all the charts in the powerpoint
changed back to the chart A

I found that each chart within Excel has the same chart name (i.e. Chart
1)
looking at the top left corner of the excel worksheet. I changed the names
of
each chart and recopied it into Powerpoint file. And my problem was
solved.

I do agree that creating the charts in different worksheets would also
resolve my problems.

Thank you for your time!

Bonji



Echo S said:
I still think that putting the charts on separate chart sheets might
help.

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


Steve Rindsberg said:
I created one chart, copied the chart onto different cell within same
tab
and
changed the data link or pointers.

We really need more specific detail than that. Imagine that your mom's
on
the other
end of the phone, knows nothing about Excel or PPT and you have to get
her
to do the
job for you. And remember: Suicide is not an option. ;-)

So you created a chart in Excel?

You copied it onto a different cell within the same tab ... by tab, do
you
mean
"Worksheet"?

Data link, pointers? What exactly did you do?

I just noticed that, the chart names of the charts I copied did not
change
or rather remains the same as original file. Could this be the major
issue?
How can i change the chart name?

Bonji

:

Bonji
wrote:
I'm using office 2007 and I linked excel charts (about 8 and all
in
one excel
tab) into different slides in Powerpoint. After a few minutes, all
the
information on the powerpoint charts would revert or change to a
single chart
in the excel tab. It appears to me that when I copy and link the
excel charts
into ppt, the link address in ppt points to one single chart in
excel
and not
the others. This started happening since I switched to office
2007.
Any ideas
on resolving this issue?????

How did you go about creating the link in the first place? Give us
the
step-by
-step ... um ... steps.

==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/


.



==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/

.
 
Ad

Advertisements


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