Share excel user defined custom chart type in powerpoint.

  • Thread starter Thread starter T-Casey
  • Start date Start date
Well, I was thinking this might be easier with 2007, since PPT 2007 uses
Excel 2007 for its charting engine. But I'm not sure and I haven't been able
to test it yet.

Anyway, with 2003, PPT uses MSGraph as its charting engine, and when you
create and save a user-defined chart in PPT (2003 and prior), it saves those
settings to the file named GRUSRGAL.GRA. This file is located in
C:\Documents and Settings\UserName\Application Data\Microsoft\Graph. You can
give users this file and have them save it to the appropriate folder -- and
then they'll have the same user-defined charts as you do. Be careful you're
not overwriting their existing user-defined charts, though! (Most users
don't even know they exist, so it's not usually a problem.)

If you save a user-defined chart in Excel, the settings are saved to
XLUSRGAL.XLS in the folder, C:\Documents and Settings\UserName\Application
Data\Microsoft\Excel.

If your users are charting in Excel, you should be able to give them that
file so they access your user-defined charts in Excel. But they'll still
have to copy/paste or Insert | Object to get those into PPT. I can't seem to
find a way to use that Excel user-defined chart in PPT itself.

Oh, wait. Do this: in PPT, use Insert | Object | Create New, select MS Excel
Chart. Then you can get to your Excel user-defined chart.

You know, now that I think of it, maybe I totally misread this question. If
you just need to show your chart in your presentation, copy it and paste it
into PPT. The whole workbook comes along for the ride.

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


T-Casey said:
Sorry,
Both are 2003
--
Tom Casey
Project Supervisor
sanofi-aventis


Echo S said:
Which version of PPT/Excel?

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


T-Casey said:
Can I share a complex user defined chart type built in Excel in my
presentation?
Click to expand...
Click to expand...
Click to expand...
 
Thank you Echo S.,

Most of this information is well documented.

I do not want to have an embedded Excel chart in the presentation. It is
large and has a lot of vba code under the hood that do not wish to include in
the presentation. Our architecture is to create the data for the presentation
in Excel and copy only this data into the PPT via VBA code.

Just thought that I should be able to share the chart formatting across
products. Seems the graph engines are virtually identical except for the data
storage.

--
Tom Casey
Project Supervisor
sanofi-aventis


Echo S said:
Well, I was thinking this might be easier with 2007, since PPT 2007 uses
Excel 2007 for its charting engine. But I'm not sure and I haven't been able
to test it yet.

Anyway, with 2003, PPT uses MSGraph as its charting engine, and when you
create and save a user-defined chart in PPT (2003 and prior), it saves those
settings to the file named GRUSRGAL.GRA. This file is located in
C:\Documents and Settings\UserName\Application Data\Microsoft\Graph. You can
give users this file and have them save it to the appropriate folder -- and
then they'll have the same user-defined charts as you do. Be careful you're
not overwriting their existing user-defined charts, though! (Most users
don't even know they exist, so it's not usually a problem.)

If you save a user-defined chart in Excel, the settings are saved to
XLUSRGAL.XLS in the folder, C:\Documents and Settings\UserName\Application
Data\Microsoft\Excel.

If your users are charting in Excel, you should be able to give them that
file so they access your user-defined charts in Excel. But they'll still
have to copy/paste or Insert | Object to get those into PPT. I can't seem to
find a way to use that Excel user-defined chart in PPT itself.

Oh, wait. Do this: in PPT, use Insert | Object | Create New, select MS Excel
Chart. Then you can get to your Excel user-defined chart.

You know, now that I think of it, maybe I totally misread this question. If
you just need to show your chart in your presentation, copy it and paste it
into PPT. The whole workbook comes along for the ride.

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


T-Casey said:
Sorry,
Both are 2003
--
Tom Casey
Project Supervisor
sanofi-aventis


Echo S said:
Which version of PPT/Excel?

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


Can I share a complex user defined chart type built in Excel in my
presentation?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top