how to chart an average of data within datasheet

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

Guest

I am trying to perform a similar function of Freelance Graphics in PowerPoint
2002. It is to total a column or row within the datasheet and only chart the
percentage of occurrence or average of each occurrence in the column or row.
 
I am trying to perform a similar function of Freelance Graphics in PowerPoint
2002. It is to total a column or row within the datasheet and only chart the
percentage of occurrence or average of each occurrence in the column or row.
Click to expand...

MSGraph, the thing that runs when you insert a graph in PPT, won't do this.

Excel, on the other hand, will do all this and more. I'd create the graphs in
Excel and copy/paste or copy/paste special/link them into PPT.

Generally you'll want to create each graph on a separate chartsheet rather than
on the datasheet in Excel.
 
Thanks! Is it possible to chart the average and only show the occurrences in
the chart table?
 
Thanks! Is it possible to chart the average and only show the occurrences in
the chart table?
Click to expand...

I'll let one of our charting and Excel wizards tackle that one. Ah, but if Excell
works for you, there's also a wealth of knowledge to call on in the Excel
newsgrooups here. Have a peek there as well.
 
What does it mean to plot just the average? You will have a single
point on the chart!

As far as showing something different in the chart table than is in the
chart, no, it cannot be done. However, you can simply simulate the
effect of a chart table. See Custom Chart Table
http://www.tushar-mehta.com/excel/newsgroups/data_table/index.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top