If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Microsoft Graph vs Embedded Excel Chart
I've been creating Powerpoint charts programmatically using VBA for
several years. I've been using embedded Excel charts. I start with a ppt file that has the Excel charts already embedded in the ppt file. Then I populate the Excel data cells with my VBA code. This worked fairly well while we were using Office 2000. Now we've upgraded to Office 2003 and I'm having trouble. The problem is when I try to manually open an embedded Excel chart (right mouse click on chart - Chart Object - Open). When I close Excel the chart shrinks in Powerpoint. This has always been flakey even in 2000 but now it's much worse in 2003. I've been experimenting with inserting a chart in Powerpoint using the Insert-Chart option found in Powerpoint instead of embedding Excel charts. I think this is called a Microsoft Graph object. This seems to be more stable but I'm not sure. Anyway here's my question. Should I use Microsoft Graph or embedded Excel charts to programmatically create charts in Powerpoint? |
#2
|
|||
|
|||
Microsoft Graph vs Embedded Excel Chart
MSGraph doesn't seem to have this same sizing problem, but sheds its own share
of flakes. By and large your Excel code can probably be adapted fairly easily to MSGraph, at least the charting portion, but there are a few things that you can't do via VBA. Setting colors other than those already supplied in the chart palette and accesing the source of linked data in the datasheet come to mind right off. In article . com, wrote: I've been creating Powerpoint charts programmatically using VBA for several years. I've been using embedded Excel charts. I start with a ppt file that has the Excel charts already embedded in the ppt file. Then I populate the Excel data cells with my VBA code. This worked fairly well while we were using Office 2000. Now we've upgraded to Office 2003 and I'm having trouble. The problem is when I try to manually open an embedded Excel chart (right mouse click on chart - Chart Object - Open). When I close Excel the chart shrinks in Powerpoint. This has always been flakey even in 2000 but now it's much worse in 2003. I've been experimenting with inserting a chart in Powerpoint using the Insert-Chart option found in Powerpoint instead of embedding Excel charts. I think this is called a Microsoft Graph object. This seems to be more stable but I'm not sure. Anyway here's my question. Should I use Microsoft Graph or embedded Excel charts to programmatically create charts in Powerpoint? ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
#3
|
|||
|
|||
Microsoft Graph vs Embedded Excel Chart
Steve Rindsberg wrote:
MSGraph doesn't seem to have this same sizing problem, but sheds its own share of flakes. By and large your Excel code can probably be adapted fairly easily to MSGraph, at least the charting portion, but there are a few things that you can't do via VBA. Setting colors other than those already supplied in the chart palette and accesing the source of linked data in the datasheet come to mind right off. That shouldn't be a problem. I'll just start with a ppt file full of blank (no data in datasheet) MSGraph charts and use it as a template. Then I'll populate the datasheets in each chart. That way I don't have to use VBA to set colors and style and things like that. Thanks! Chuck. |
#4
|
|||
|
|||
Microsoft Graph vs Embedded Excel Chart
In article . com, wrote:
Steve Rindsberg wrote: MSGraph doesn't seem to have this same sizing problem, but sheds its own share of flakes. By and large your Excel code can probably be adapted fairly easily to MSGraph, at least the charting portion, but there are a few things that you can't do via VBA. Setting colors other than those already supplied in the chart palette and accesing the source of linked data in the datasheet come to mind right off. That shouldn't be a problem. I'll just start with a ppt file full of blank (no data in datasheet) MSGraph charts and use it as a template. Then I'll populate the datasheets in each chart. That way I don't have to use VBA to set colors and style and things like that. You may need to fill the charts with dummy data before you can format it. I may've missed some little trick or other but near's I can tell, MSGraph won't let you format data that isn't there. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
#5
|
|||
|
|||
Microsoft Graph vs Embedded Excel Chart
Steve Rindsberg wrote:
You may need to fill the charts with dummy data before you can format it. I may've missed some little trick or other but near's I can tell, MSGraph won't let you format data that isn't there. Yup. I had to put dummy data in my embedded excel worksheets, format the chart, then delete the data. Actually deleting the data is probably unnecessary since I overwrite it. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Difference between Microsoft Graph and Excel Chart | mrcrouter | General Discussion | 0 | October 14th, 2005 03:49 PM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Microsoft Graph Chart in Access 2000/2003 ADP | Grasshopper | Setting Up & Running Reports | 1 | September 20th, 2004 10:03 PM |
Recent Microsoft Excel Updates - March 24, 2004 | Rita Nikas [MSFT] | Worksheet Functions | 0 | March 24th, 2004 05:11 PM |