Advertisement

10.10.2008 at 02:25PM PDT, ID: 23805552
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.3

PPT 2007 Need To Programmatically Edit Data In WorkSheet Cells Behind The Chart

Asked by VITIX in Microsoft Powerpoint Presentation Software, Microsoft Visual Basic.Net

Tags: ,

Up until now I have been generating PPT files by opening a PPT template,
pulling records from Access, and using VBA code to populate the tables and
graphs on the slides with data from the Access queries. The tables are easy,
while the graphs I updated by putting data values into the graph's datasheet
cells.

Now with PPT 2007 the graphs are different. The datasheet is more like an
Excel worksheet, with a "Chart" tab and a "Sheet1" tab at the bottom (or a split window). I have
tried every syntax I can think of to talk to this new type of datasheet using
VBA, but nothing works.

Now I read on various forums that the new PPT 2007 Chart object does not
expose any methods that can be addressed using VBA.

So I started writing an application to manipulate PPT slides using VB.Net.
But I cannot find any examples that show how to use VB.Net code to
programmatically update the data in the worksheet behind the chart.

What is the big secret to updating the sheet cells in PPT 2007 charts?
Where is the answer to this found in the documentation for the 2007 PPT object model? I cant believe the
ability to address datasheet cells direclty in code has been taken away.

Does anybody know how to do this without reverting back to the old MSGraph model?

Thanks for any help!
VITIXStart Free Trial
[+][-]10.12.2008 at 05:50PM PDT, ID: 22699621

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 14-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.13.2008 at 12:29PM PDT, ID: 22705502

View this solution now by starting your 14-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Powerpoint Presentation Software, Microsoft Visual Basic.Net
Tags: vb.net, ie6
Sign Up Now!
Solution Provided By: GlennaShaw
Participating Experts: 1
Solution Grade: A
 
 
[+][-]10.14.2008 at 02:28PM PDT, ID: 22716164

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 14-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-43 - Hierarchy / EE_QW_2_20070628