Can an excel graph placed in ppt 2007 be opened in 2003?

  • Thread starter Thread starter rathbunct
  • Start date Start date
R

rathbunct

I am generating graphs utilizing Excel and PowerPoint 2007, but others are
using Office 2003. They would like to be able to edit the data within the
graphs, but when I save it in a lower version, all graphs loose their
editability and become images. Is there anyway around this?
 
Rathbunct said:
I am generating graphs utilizing Excel and PowerPoint 2007, but others are
using Office 2003. They would like to be able to edit the data within the
graphs, but when I save it in a lower version, all graphs loose their
editability and become images. Is there anyway around this?
Click to expand...

Here's an answer from the PowerPoint FAQ at http://www.pptfaq.com

HKEY_CURRENT_USER/SOFTWARE/MICROSOFT/OFFICE/12.0/Common/Charting/MSGraphEnable

If you add this key (DWORD) and set it to 1, the following happens:

PowerPoint won't prompt the to convert existing MSGraph charts when you
double-click them. It simply treats it as earlier PPT versions normally treat
MSGraph charts.

When you insert a new chart or click the chart icon in a content placeholder,
PowerPoint inserts an MSGraph chart rather than the new-style Excel ones.

PowerPoint won't convert MSGraph charts if the user opens a legacy document and
clicks on OfficeButton, Convert.
 
Hi Steve, thanks for the response. While it does seem to answer the
question, I am still at a loss as to how? It looks like I may have to do
some coding but I'm unclear where to begin. Forgive my lack of knowledge.
Do I follow the instructions at pptfaq.com on "How do I use VBA code in
PowerPoint?" Thanks for your patience. Christine
 
Yeah, I was thinking that FAQ isn't terribly clear with respect to what
you're asking. Let me see if I can do any better. Maybe not, but I'll give
it a shot. :-)

If you're going back and forth between 2007 and 2003, and editing charts is
a consideration, you really want to stick with MS Graph charts. In PPT 2007,
when you insert a chart, it automatically inserts an Excel chart. You can
change that key in the registry so that when you choose Insert | Chart, PPT
will instead insert an MS Graph chart.

When your uses double-click that MS Graph chart in PPT 2003, it will behave
just like the charts they're used to working with.

I can't find the specific FAQ Steve's quoting from, but what he's saying is
you need to edit the registry on the PPT 2007 machine and add this registry
key:
HKEY_CURRENT_USER/SOFTWARE/MICROSOFT/OFFICE/12.0/Common/Charting/MSGraphEnable

and set its value to 1.

So, navigate to this folder in the registry:
HKEY_CURRENT_USER/SOFTWARE/MICROSOFT/OFFICE/12.0/Common/Charting/
then Edit | New | Dword
type MSGraphEnable
and set the data value to 1

This will allow you to insert a MSGraph chart instead of an Excel chart when
you Insert | Chart, and it will also not convert the MSGraph charts to Excel
charts (which is PPT 2007's typical behavior), so you can stick with MSGraph
all the way 'round.
 
Hi Christine,

Sorry, that was a quick grab from a FAQ that wasn't really ready for human
consumption yet. ;-)

What it means is that you'd need to add a new registry entry here:

HKEY_CURRENT_USER/SOFTWARE/MICROSOFT/OFFICE/12.0/Common/Charting/MSGraphEnable

The entry should be a DWORD and should be set to a value of 1

No VBA or coding is needed, but if you're not familiar with editing the Windows
registry, it would be best to find someone who is and ask them to make this change.

Making the wrong changes in the registry can muck things up pretty badly.
 
Thanks so much to both of you! I really appreciate all your help. I am not
familiar with editing the Windows registry, but I'm sure I can find someone
at my workplace that can help me out with that. I'm just so excited to find
that it is possible as I would have to go back a version. :)

Echo S said:
Yeah, I was thinking that FAQ isn't terribly clear with respect to what
you're asking. Let me see if I can do any better. Maybe not, but I'll give
it a shot. :-)

If you're going back and forth between 2007 and 2003, and editing charts is
a consideration, you really want to stick with MS Graph charts. In PPT 2007,
when you insert a chart, it automatically inserts an Excel chart. You can
change that key in the registry so that when you choose Insert | Chart, PPT
will instead insert an MS Graph chart.

When your uses double-click that MS Graph chart in PPT 2003, it will behave
just like the charts they're used to working with.

I can't find the specific FAQ Steve's quoting from, but what he's saying is
you need to edit the registry on the PPT 2007 machine and add this registry
key:
HKEY_CURRENT_USER/SOFTWARE/MICROSOFT/OFFICE/12.0/Common/Charting/MSGraphEnable

and set its value to 1.

So, navigate to this folder in the registry:
HKEY_CURRENT_USER/SOFTWARE/MICROSOFT/OFFICE/12.0/Common/Charting/
then Edit | New | Dword
type MSGraphEnable
and set the data value to 1

This will allow you to insert a MSGraph chart instead of an Excel chart when
you Insert | Chart, and it will also not convert the MSGraph charts to Excel
charts (which is PPT 2007's typical behavior), so you can stick with MSGraph
all the way 'round.

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


rathbunct said:
Hi Steve, thanks for the response. While it does seem to answer the
question, I am still at a loss as to how? It looks like I may have to do
some coding but I'm unclear where to begin. Forgive my lack of knowledge.
Do I follow the instructions at pptfaq.com on "How do I use VBA code in
PowerPoint?" Thanks for your patience. Christine
Click to expand...
Click to expand...
 
I can't find the specific FAQ Steve's quoting from,

You're not a non-human is why. As I mentioned, it's not ready for human
consumption, so the PPT FAQ knows not to show it to you. ;-)

But I'm gonna steal some of this to help nudge it along. Thanks.

but what he's saying is
 
Steve,
You are correct that Echo is not a human. She's a Who'sier (vbg)
Brian Reilly, MVP
 
Hi Steve,

I do not have the suggested Reg Key, but i am using a currently unsupported
version of 2007 within my company (am on pilot scheme).

Was this key added as part of SP1 for Office? I am not able to get any
updates so cannot check by installing the SP?

Is there any other options other than a Reg Fix?

Thanks so much again :)
 
I don't think there are any other options other than the reg fix.

SP1 doesn't add this key, but you can add it to your registry (or maybe ask
one of your IT people to do it for you).
 
Thaks so much! But, with a little more perserverence, we found another fix.
If you
Insert Object/Create from file/Browse and choose your excel file. You'll
have to double click on it and choose the sheet you want, but it acts just as
in the old version.

Thanks for all your support!

Christine



Echo S said:
I don't think there are any other options other than the reg fix.

SP1 doesn't add this key, but you can add it to your registry (or maybe ask
one of your IT people to do it for you).

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


rathbunct said:
Hi Steve,

I do not have the suggested Reg Key, but i am using a currently
unsupported
version of 2007 within my company (am on pilot scheme).

Was this key added as part of SP1 for Office? I am not able to get any
updates so cannot check by installing the SP?

Is there any other options other than a Reg Fix?

Thanks so much again :)
Click to expand...
Click to expand...
 
But if you apply 2007 formatting to these Excel graphs, you may run into
issues. I don't know if the graphs inserted this way will become completely
uneditable the way the others do, though. Hm. Interesting....

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


rathbunct said:
Thaks so much! But, with a little more perserverence, we found another
fix.
If you
Insert Object/Create from file/Browse and choose your excel file. You'll
have to double click on it and choose the sheet you want, but it acts just
as
in the old version.

Thanks for all your support!

Christine



Echo S said:
I don't think there are any other options other than the reg fix.

SP1 doesn't add this key, but you can add it to your registry (or maybe
ask
one of your IT people to do it for you).

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


rathbunct said:
Hi Steve,

I do not have the suggested Reg Key, but i am using a currently
unsupported
version of 2007 within my company (am on pilot scheme).

Was this key added as part of SP1 for Office? I am not able to get any
updates so cannot check by installing the SP?

Is there any other options other than a Reg Fix?

Thanks so much again :)

:

Hi Christine,

Sorry, that was a quick grab from a FAQ that wasn't really ready for
human
consumption yet. ;-)

What it means is that you'd need to add a new registry entry here:

HKEY_CURRENT_USER/SOFTWARE/MICROSOFT/OFFICE/12.0/Common/Charting/MSGraphEnable

The entry should be a DWORD and should be set to a value of 1

No VBA or coding is needed, but if you're not familiar with editing
the
Windows
registry, it would be best to find someone who is and ask them to make
this change.

Making the wrong changes in the registry can muck things up pretty
badly.

Hi Steve, thanks for the response. While it does seem to answer the
question, I am still at a loss as to how? It looks like I may have
to
do
some coding but I'm unclear where to begin. Forgive my lack of
knowledge.
Do I follow the instructions at pptfaq.com on "How do I use VBA code
in
PowerPoint?" Thanks for your patience. Christine

:

Rathbunct
wrote:
I am generating graphs utilizing Excel and PowerPoint 2007, but
others are
using Office 2003. They would like to be able to edit the data
within the
graphs, but when I save it in a lower version, all graphs loose
their
editability and become images. Is there anyway around this?

Here's an answer from the PowerPoint FAQ at http://www.pptfaq.com

HKEY_CURRENT_USER/SOFTWARE/MICROSOFT/OFFICE/12.0/Common/Charting/MSGraphEnable

If you add this key (DWORD) and set it to 1, the following
happens:

PowerPoint won't prompt the to convert existing MSGraph charts
when
you
double-click them. It simply treats it as earlier PPT versions
normally treat
MSGraph charts.

When you insert a new chart or click the chart icon in a content
placeholder,
PowerPoint inserts an MSGraph chart rather than the new-style
Excel
ones.

PowerPoint won't convert MSGraph charts if the user opens a legacy
document and
clicks on OfficeButton, Convert.


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================





-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Click to expand...
Click to expand...
Click to expand...
 
Thanks for the explanations all of you.

I have applied this procedure on my computer as we are doing back and forth
between 2003 and 2007 versions and using extensively graphics.

It does help to make tis registry tweak and work all on MS Graph.

HOWEVER,
I am facing a flight problem.
It seems that with PPT2007, MS graph does not remember when we set a custom
type graph as default. it always starts with a standard type and the Calibri
font.

Any Idea on how to solve this ?

Thanks a lot
 
Thanks Steve.

How sad....
I am working on this compatibility since a full week now and I "lost a lot
of hairs" (as we say in france)
 
But we are facing a big bug from Microsoft.

because, there is a button called "set as default chart" in MS Graph that is
delivered with Office 2007 and still it does not allow to set custom charts
as default.
I also tried to import the Grusrgal.gra file that we have generated under
PPT 2003, that can be red under 2007 version, but still we have the Calibri
20 font that comes back...
 
What's the default font for your presentation? That is, what fonts are used
for "heading" and "body"? And then, what fonts have you specified on the
slide masters and layouts?
 
My templates (master, layout...) are all set to Arial.
My default theme font is (Arial for heading and body)

and still MS Graph sticks to "default chart styles" (the "set as default"
button allows to select a different "standard chart type" that are all based
on Calibri but none of the Custom Chart types)

Any idea ?

Echo S said:
What's the default font for your presentation? That is, what fonts are used
for "heading" and "body"? And then, what fonts have you specified on the
slide masters and layouts?

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


Nicolo said:
But we are facing a big bug from Microsoft.

because, there is a button called "set as default chart" in MS Graph that
is
delivered with Office 2007 and still it does not allow to set custom
charts
as default.
I also tried to import the Grusrgal.gra file that we have generated under
PPT 2003, that can be red under 2007 version, but still we have the
Calibri
20 font that comes back...
Click to expand...
Click to expand...
 
Steve Rindsberg said:
In PPT 2003 and previous, you can choose Tools, Options and on the Edit
tab, put a check
next to "New charts take on PPT font". If you do that, any new charts you
add will
appear in the same font as the master slide's title placeholder.

Changing this in PPT sets a value in the registry to 1 or 0.
HKCU\Software\Microsoft\Office\11\PowerPoint\Options
PPTColorsForNewGraphs

Adding the same entry to the Office 12 (2007) section doesn't seem to have
any effect,
alas.
Click to expand...

You knew where I was going, didn't you? :-)

I couldn't even find that option in PPT 2007, though -- seems it must be a
registry-only hack now (that doesn't work, anyway?).
 
I am impressed and very happy to have the 2 top guns of PPT tweaking.
Thanks a lot.

I have 1 question and 2 investigation results to present you.

1. I have always unchecked the New graph takes on PPT font on the PPT 2003
applications.
In fact, when this option is checked and you copy a slide from a different
presentation, the graphs are updated with Arial 18 Bold, whereas I would like
to have Arial 12 font.
I don't understand where to set this Bold 18 Font.
in my template, my Title Layout is in Arial 20 Bold, and my text layout is
in Arial 14 not-bold, and the default Font for a new text box is Arial 12
not-bold
Could you explain me where to fix this 18 default font ??

Anyhow, we've got a setting that works pretty well with only PPT 2003

2. on PPT 2007, I have investigated in the Registry the default graph
parameters.
If a set a custom graph as default under MS Graph, the reg
HKCU\Software\Miscosoft\Office\12.0\Graph\Options\Default Chart is updated
to "User Defined:My Chart"
But as soon as you insert a new graph in a slide, the registry is updated to
"Standard:1.1"
If it is not a bug, what is it ?

3. I confirm that the PPTColorsForNewgraph does not change any thing to PPT
2007 beahaviours
 
1. I have always unchecked the New graph takes on PPT font on the PPT 2003
I haven't had a chance to try this but I suspect you can format a chart as desired
then save it as a custom chart type, then set that as the default chart.
At least in 2003.
Click to expand...

That is the interesting point.

My default chart is in Font 12, but anyhow, with this option checked in, PPT
changes the inserted graph with 18 bold...


By the way, if you click just inside the chart's borders when the chart is active
(that is, so that the Chart Area is the active selection) then you can change the
font formatting for all text in the chart at once.
Click to expand...

Yes I know. thanks anyway


Thanks a lot to all of you for your help
 
Back
Top