 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / April 2008Can an excel graph placed in ppt 2007 be opened in 2003?
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? > 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 ================================================ 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 > > 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 [quoted text clipped - 22 lines] > PPTools: www.pptools.com > ================================================ 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.  SignatureEcho [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 > 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 [quoted text clipped - 36 lines] >> PPTools: www.pptools.com >> ================================================ 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. :) > 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 [quoted text clipped - 67 lines] > >> PPTools: www.pptools.com > >> ================================================ > 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 > you need to edit the registry on the PPT 2007 machine and add this registry > key: [quoted text clipped - 12 lines] > charts (which is PPT 2007's typical behavior), so you can stick with MSGraph > all the way 'round. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Steve, You are correct that Echo is not a human. She's a Who'sier (vbg) Brian Reilly, MVP >> I can't find the specific FAQ Steve's quoting from, > [quoted text clipped - 26 lines] >PPTools: www.pptools.com >================================================ 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 [quoted text clipped - 28 lines] > > PPTools: www.pptools.com > > ================================================ ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ 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, > [quoted text clipped - 50 lines] > PPTools: www.pptools.com > ================================================ 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). SignatureEcho [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 > Hi Steve, > [quoted text clipped - 79 lines] >> PPTools: www.pptools.com >> ================================================ 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 > I don't think there are any other options other than the reg fix. > [quoted text clipped - 84 lines] > >> PPTools: www.pptools.com > >> ================================================ 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.... SignatureEcho [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 > Thaks so much! But, with a little more perserverence, we found another > fix. [quoted text clipped - 104 lines] >> >> PPTools: www.pptools.com >> >> ================================================ 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 > > 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 [quoted text clipped - 22 lines] > PPTools: www.pptools.com > ================================================ > Thanks for the explanations all of you. > [quoted text clipped - 8 lines] > type graph as default. it always starts with a standard type and the Calibri > font. Unfortunately, you can't set default graphs using MS Graph. You could include a ready-made graph slide in your template and have the user copy and paste it to create new slides, though. > Thanks a lot > [quoted text clipped - 24 lines] > > PPTools: www.pptools.com > > ================================================ ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ 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) > > Thanks for the explanations all of you. > > [quoted text clipped - 48 lines] > PPTools: www.pptools.com > ================================================ > 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) Plus ça change ... Many of us here are bald too. ;-) ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ 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... > > Thanks for the explanations all of you. > > [quoted text clipped - 48 lines] > PPTools: www.pptools.com > ================================================ 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? SignatureEcho [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 > But we are facing a big bug from Microsoft. > [quoted text clipped - 75 lines] >> PPTools: www.pptools.com >> ================================================ 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 ? > 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 [quoted text clipped - 79 lines] > >> PPTools: www.pptools.com > >> ================================================ > 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) 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. > Any idea ? > [quoted text clipped - 81 lines] > > >> PPTools: www.pptools.com > > >> ================================================ ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ >> My templates (master, layout...) are all set to Arial. >> My default theme font is (Arial for heading and body) [quoted text clipped - 17 lines] > any effect, > alas. 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?). SignatureEcho [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 > > Adding the same entry to the Office 12 (2007) section doesn't seem to have > > any effect, > > alas. > > You knew where I was going, didn't you? :-) Nice of your mind to share the gutter with mine <g> > 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?). Yep. Went looking for the setting in 2007 first and started in dancin' The Registry Poke-a when I couldn't find it in the UI. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ 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 > > > Adding the same entry to the Office 12 (2007) section doesn't seem to have > > > any effect, [quoted text clipped - 15 lines] > PPTools: www.pptools.com > ================================================ > 1. I have always unchecked the New graph takes on PPT font on the PPT 2003 > applications. [quoted text clipped - 6 lines] > not-bold > Could you explain me where to fix this 18 default font ?? 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. 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. > 2. on PPT 2007, I have investigated in the Registry the default graph > parameters. [quoted text clipped - 4 lines] > "Standard:1.1" > If it is not a bug, what is it ? If you don't stop soon, we will all need wigs. ;-) A bug, surely. I can confirm the same behavior here. I'll pass it along. > 3. I confirm that the PPTColorsForNewgraph does not change any thing to PPT > 2007 beahaviours Do I get some hair back for that? > > > > Adding the same entry to the Office 12 (2007) section doesn't seem to have > > > > any effect, [quoted text clipped - 15 lines] > > PPTools: www.pptools.com > > ================================================ ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ > > 1. I have always unchecked the New graph takes on PPT font on the PPT 2003 > > applications. [quoted text clipped - 10 lines] > then save it as a custom chart type, then set that as the default chart. > At least in 2003. 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. Yes I know. thanks anyway Thanks a lot to all of you for your help >> > 1. I have always unchecked the New graph takes on PPT font on the PPT >> > 2003 [quoted text clipped - 22 lines] > PPT > changes the inserted graph with 18 bold... In PPT 2003, that might be because of that "new charts take on PPT font" setting in Tools | Options | Edit. Oh, wait. You knew that. LOL! Sorry. Getting lost in this thread! :-) Anyway, the "PPT font" that the charts are taking on has to do with your title placeholder font. (I think you know that also.) The size, however, defaults to 18 pt bold if you have that "new charts take on PPT font" setting selected. (I don't know where the 18 point bold specifically comes from, but it is indeed the default if "new charts take on PPT font" is selected.) If you uncheck "new charts take on PPT font," the chart's font size will respect what you've set in the user-defined default chart you've specified. SignatureEcho [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 Thanks Echo Some News : My Excel default font was calibi If you switch the excel font to Arial, then the new MS grahs are in Arial (But Arial 20 bold, which does not suits me) Did you know that ?? I am impressed to see how thricky this Office Suite is...
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.