 |
 | 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 / October 2007Dynamic charts
Hi All, I need to create a presentation in PowerPoint that requires me to produce charts that dynamic change. The problem is that the numbers that drive the charts have got to embedded into text on the presentation page layout and not a table. Can this be done? I've been looking at this problem from a VBA angle but cannot see how to "call" a chart with VBA Please help!! Regards, Fuzz > Hi All, > I need to create a presentation in PowerPoint that requires me to produce > charts that dynamic change. > The problem is that the numbers that drive the charts have got to embedded > into text on the presentation page layout and not a table. Do you need to be able to edit the text on the PPT slide and see the charts change, or do you need to be able to change the data somewhere, and have the chart and the text in PPT both update to follow it? I'm wondering if you could link to a chart in Excel and also link the text to the data in the same Excel sheet that drives the chart. If not, fill in some more info: Is the chart in Excel or MSGraph? Do you need to be able to support 2007? Can you install an add-in of your own making on the machines where this'll work or does it need to run on pretty much any computer? How're your VBA skills? This might not be rocket science, but it's not a beginner's project. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Hi Steve, Thanks for your response...and sorry for my late answer!...been too busy of late. This will need to run on just about any PC and my VB skills are ok, but not that strong! I need to be able to change the data somewhere, and have the charts and the text in PPT both update to follow it...but this needs to be instantaneous (without a manual update). Not sure to the following: > I'm wondering if you could link to a chart in Excel and also link the text > to > the data in the same Excel sheet that drives the chart. The data and charts are currently Excel...I have tried using PowerPoint charts too and I haven't even considered MS Graph!! Most of the users will be using 2003 Ken (fuzz) >> Hi All, >> I need to create a presentation in PowerPoint that requires me to produce [quoted text clipped - 31 lines] > PPTools: www.pptools.com > ================================================ Hi Ken > This will need to run on just about any PC and my VB skills are ok, but not > that strong! Writing the VB is do-able but not all that simple, but it may not run on a lot of PCs due to PPT macro security settings, and won't run at all on PCs where the user's only got the PPT Viewer and not the full PPT. Sounds like VB's a non-starter. > I need to be able to change the data somewhere, and have the charts and the > text in PPT both update to follow it...but this needs to be instantaneous > (without a manual update). Text and charts linked from a spreadsheet would work, so long as you supplied the spreadsheet along with the PPT file (or rather, it'd work in full PPT ... again, not in the Viewer). And the users will probably see a prompt asking if it's ok to update. > The data and charts are currently Excel...I have tried using PowerPoint > charts too and I haven't even considered MS Graph!! MSGraph = PPT Charts. When you insert a chart in PPT, an MSGraph chart is what you get, at least in PPT 2003 and prior. So I'd do some testing with Excel, both text and charts linked into PPT. > news:VA.000038ad.326135e9@localhost.com... > >> Hi All, [quoted text clipped - 32 lines] > > PPTools: www.pptools.com > > ================================================ ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Thanks Steve. I shall try the Excel linked to PPT route. But I am interested in knowing how to create a bar chart (with two bars) where the data is taken from two number text box/field. Regards, Ken > Hi Ken > [quoted text clipped - 79 lines] > PPTools: www.pptools.com > ================================================ > Thanks Steve. > I shall try the Excel linked to PPT route. > But I am interested in knowing how to create a bar chart (with two bars) > where the data is taken from two number text box/field. Have a look here for something to get you started: Working with MSGraph charts http://www.pptfaq.com/index.html#name_Working_with_MSGraph_charts ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
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.