How to total data sheets on all power point slides?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to "roll-up" a total onto one slide totalling data from the
data sheets from all the slides in a presentation.
 
I need to be able to "roll-up" a total onto one slide totalling data from the
data sheets from all the slides in a presentation.
Click to expand...

Powerpoint doesn't have datasheets of its own, so the first question would be
where these datasheets come from?

Also, what version of PowerPoint do you use?
 
When I click on the graph within the powerpoint slide, the data sheet pops up
where as I can enter data into the data sheet. There are data sheets in
Powerpoint. Powerpoint even lists the options of viewing data sheet. I just
got this computer from Dell one month ago... so I would assume it is the
latest version of Power Point. I sure appreciate any help I can receive.
 
When I click on the graph within the powerpoint slide, the data sheet pops up
where as I can enter data into the data sheet. There are data sheets in
Powerpoint. Powerpoint even lists the options of viewing data sheet. I just
got this computer from Dell one month ago... so I would assume it is the
latest version of Power Point. I sure appreciate any help I can receive.
Click to expand...

OK, we're on the same page. Great.

It may seem odd, but what you see when you do this is actually a different program
called MSGraph, but through some bits of Windows magic, when it's active within
PowerPoint, its menus appear on the PPT menu bar and such. It sure *looks* like
it's part of PowerPoint, though it's not.

PowerPoint itself can't do any totaling on the data in these charts.
You could write, or hire somebody to write, VBA (Visual Basic for Applications ...
PowerPoint's macro language) to do the job, but it wouldn't be a trivial project.

Instead, I'd put all my data into Excel, create each of my charts there (each on its
own chart sheet). Select each chart in turn, choose Edit, Copy; switch to PPT and
choose Edit, Paste Special, Link. That puts your chart in PPT but with a link back
to the original chart in Excel, and the chart there is linked to the Exel data.
Change the data, the chart changes and the next time you open your PPT, the charts
there update as well.

You could also use Excel to sum the data or do any other manipulations on it you
like and copy/paste Special/Link the worksheet into PPT.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locking a single slide in a presentation 0
Automically add information from one text box to another 0
Problem with one presentation 0
fixes for embeded hard coded errors for power point slides 1
PowerPoint VBA question 1
Some presentation slide first bullet points (but not all) print inthe wrong color when printing Blac 1
CUSTOM ANIMATION 8
about slide numbering 2

Back
Top