PowerPoint 2007 Chart question


S

Shawn

I have two questions. When I insert a chart in PP 2007 and "edit data"
a new Excel spreadsheet windows opens at half size. My first question
- is there a way to have the charts behave like 2003, where the sheet
with the data is in the same file as the chart in PPT?

Second, is there a way to prevent PPT from resizing all of my other
open Excel 2007 windows to half size every time I edit the chart data
in PPT? In other words, every time I edit data from a PPT chart, all
of my other open Excel windows are reduced to half size and I have to
resize them.

Many thanks in advance!
 
Ad

Advertisements

E

Echo S

When you insert a chart in PPT 2007, the Excel window opens with dummy data,
and the chart appears on your slide.

This sheet and chart is embedded in your PPT file. Sure, it opens in a
separate window, but it is indeed embedded in your PPT file.

Just wanted to make that clear.

Now, if what you're asking is if there's a way to go back to the old
2003-style MSGraph charts, then yes, you can do that.

Use Insert | Object and choose MS Graph Chart.

Or you can do a registry hack so that when you insert a chart using Insert |
Chart, it's the old MSGraph charts by default instead of the new Excel-style
charts. I do not recommend this, really, as the color schemes don't work the
same in the old Graph charts as they do in PPT 2007, so sometimes your
colors mess up, and if you have others editing files in 2007, it is more
difficult for them to deal with.

Using MSGraph with PowerPoint 2007
http://www.pptfaq.com/FAQ00872.htm

I don't know of a way to prevent the resizing, sorry.
 
Ad

Advertisements

S

Shawn

Thanks for the reply. I realize the Excel data is embedded but I found
it much easier to use when a new window didn't open up for me to edit.
It is the resizing of all other open Excel workbooks that really
drives me nuts. When working with powerpoint and multiple workbooks
simultaneously like I do all day, it ends up creating a lot of extra
work to resize the windows with every data edit. I guess that is the
trade off for the 2007 features. Thanks again for your response. The
MVP's are most helpful in these groups.

When you insert a chart in PPT 2007, the Excel window opens with dummy data,
and the chart appears on your slide.

This sheet and chart is embedded in your PPT file. Sure, it opens in a
separate window, but it is indeed embedded in your PPT file.

Just wanted to make that clear.

Now, if what you're asking is if there's a way to go back to the old
2003-style MSGraph charts, then yes, you can do that.

Use Insert | Object and choose MS Graph Chart.

Or you can do a registry hack so that when you insert a chart using Insert |
Chart, it's the old MSGraph charts by default instead of the new Excel-style
charts. I do not recommend this, really, as the color schemes don't work the
same in the old Graph charts as they do in PPT 2007, so sometimes your
colors mess up, and if you have others editing files in 2007, it is more
difficult for them to deal with.

Using MSGraph with PowerPoint 2007http://www.pptfaq.com/FAQ00872.htm

I don't know of a way to prevent the resizing, sorry.

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




I have two questions. When I insert a chart in PP 2007 and "edit data"
a new Excel spreadsheet windows opens at half size. My first question
- is there a way to have the charts behave like 2003, where the sheet
with the data is in the same file as the chart in PPT?
Second, is there a way to prevent PPT from resizing all of my other
open Excel 2007 windows to half size every time I edit the chart data
in PPT? In other words, every time I edit data from a PPT chart, all
of my other open Excel windows are reduced to half size and I have to
resize them.
Many thanks in advance!

T
 

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