graphs

  • Thread starter Thread starter ann
  • Start date Start date
A

ann

I have added a graph to a slide. However, I would like to
add a worksheet that I can use to calculate a formula that
I can use, but it changes the data in my graph.

Is there a way I can use the data sheet to do a formula
without it affecting the graph?
 
ann said:
I have added a graph to a slide. However, I would like to
add a worksheet that I can use to calculate a formula that
I can use, but it changes the data in my graph.

Is there a way I can use the data sheet to do a formula
without it affecting the graph?
Click to expand...

PowerPoint's datasheet doesn't do formulas, so I'd suggest you use Excel
instead.

There've been quite a few threads on using Excel Pivot Tables lately
here for some odd reason. That might work for you, too. Tushar Mehta,
Excel MVP Extraordinaire, wrote a tutorial you can peruse to see if this
might be a solution for you. http://www.tushar-mehta.com
 
Back
Top