Link data from Excel 2007 to PowerPoint 2007

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

I am using Office 2007. I am creating a column chart in PowerPoint, and I
want to copy my data from Excel with a link. I begin a chart slide. I copy
the data from Excel, switch to PowerPoint, and when I attempt to “paste linkâ€
the data into the data sheet in PowerPoint, the “link†option is faded out.
So, I delete the current data in the data sheet of PowerPoint, and I can then
link. Now I decide to type into the PowerPoint data sheet an additional
column of data (not from Excel), but this data isn’t reflected in the column
chart. I’m sure it has something to do with deleting the data from the
sample data sheet in PowerPoint because it also deleted the border to
increase the size of the data range. What is the solution? How do I get
that border back so that I can increase the size of the data range so that my
new data is reflected in my column chart? This was all so easy in Office
2003. Thanks!
 
On the Chart Tools Design tab, click the Select Data button. That pulls up a
dialog that has the chart data range at the top. You can change the last
cell there -- from $D$5 to whatever cell you need, for an additional column
it would be $E$5.
 
This did work, but it defintely has added a some steps that we didn't need to
do in previous versions. In previous versions, I would just add the
information to the Data Sheet and it would dynamically update the chart. I
do thank you for this suggestion...

Echo S said:
On the Chart Tools Design tab, click the Select Data button. That pulls up a
dialog that has the chart data range at the top. You can change the last
cell there -- from $D$5 to whatever cell you need, for an additional column
it would be $E$5.

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


Jean said:
I am using Office 2007. I am creating a column chart in PowerPoint, and I
want to copy my data from Excel with a link. I begin a chart slide. I
copy
the data from Excel, switch to PowerPoint, and when I attempt to “paste
linkâ€
the data into the data sheet in PowerPoint, the “link†option is faded
out.
So, I delete the current data in the data sheet of PowerPoint, and I can
then
link. Now I decide to type into the PowerPoint data sheet an additional
column of data (not from Excel), but this data isn’t reflected in the
column
chart. I’m sure it has something to do with deleting the data from the
sample data sheet in PowerPoint because it also deleted the border to
increase the size of the data range. What is the solution? How do I get
that border back so that I can increase the size of the data range so that
my
new data is reflected in my column chart? This was all so easy in Office
2003. Thanks!
Click to expand...
Click to expand...
 
I know, and I understand it's frustrating. While I love the fact that
charting in Office 2007 now has all the Excel features, I dislike the fact
that things like this aren't very intuitive.

But hey, at least we get a dummy chart to start with! In Excel, they don't.
(Excel users don't really want a dummy chart, though; PPT users generally
do. It's an interesting contrast in usage styles, I think.)

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


Jean said:
This did work, but it defintely has added a some steps that we didn't need
to
do in previous versions. In previous versions, I would just add the
information to the Data Sheet and it would dynamically update the chart.
I
do thank you for this suggestion...

Echo S said:
On the Chart Tools Design tab, click the Select Data button. That pulls
up a
dialog that has the chart data range at the top. You can change the last
cell there -- from $D$5 to whatever cell you need, for an additional
column
it would be $E$5.

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


Jean said:
I am using Office 2007. I am creating a column chart in PowerPoint, and
I
want to copy my data from Excel with a link. I begin a chart slide.
I
copy
the data from Excel, switch to PowerPoint, and when I attempt to “paste
linkâ€
the data into the data sheet in PowerPoint, the “link†option is faded
out.
So, I delete the current data in the data sheet of PowerPoint, and I
can
then
link. Now I decide to type into the PowerPoint data sheet an
additional
column of data (not from Excel), but this data isn’t reflected in the
column
chart. I’m sure it has something to do with deleting the data from the
sample data sheet in PowerPoint because it also deleted the border to
increase the size of the data range. What is the solution? How do I
get
that border back so that I can increase the size of the data range so
that
my
new data is reflected in my column chart? This was all so easy in
Office
2003. Thanks!
Click to expand...
Click to expand...
Click to expand...
 
You have been very helpful! Thanks again!

Echo S said:
I know, and I understand it's frustrating. While I love the fact that
charting in Office 2007 now has all the Excel features, I dislike the fact
that things like this aren't very intuitive.

But hey, at least we get a dummy chart to start with! In Excel, they don't.
(Excel users don't really want a dummy chart, though; PPT users generally
do. It's an interesting contrast in usage styles, I think.)

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


Jean said:
This did work, but it defintely has added a some steps that we didn't need
to
do in previous versions. In previous versions, I would just add the
information to the Data Sheet and it would dynamically update the chart.
I
do thank you for this suggestion...

Echo S said:
On the Chart Tools Design tab, click the Select Data button. That pulls
up a
dialog that has the chart data range at the top. You can change the last
cell there -- from $D$5 to whatever cell you need, for an additional
column
it would be $E$5.

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


I am using Office 2007. I am creating a column chart in PowerPoint, and
I
want to copy my data from Excel with a link. I begin a chart slide.
I
copy
the data from Excel, switch to PowerPoint, and when I attempt to “paste
linkâ€
the data into the data sheet in PowerPoint, the “link†option is faded
out.
So, I delete the current data in the data sheet of PowerPoint, and I
can
then
link. Now I decide to type into the PowerPoint data sheet an
additional
column of data (not from Excel), but this data isn’t reflected in the
column
chart. I’m sure it has something to do with deleting the data from the
sample data sheet in PowerPoint because it also deleted the border to
increase the size of the data range. What is the solution? How do I
get
that border back so that I can increase the size of the data range so
that
my
new data is reflected in my column chart? This was all so easy in
Office
2003. Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top