how to chart an average of data within datasheet

[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.

 

[Steve Rindsberg]

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.

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.

 

[Guest]

Thanks! Is it possible to chart the average and only show the occurrences in
the chart table?

 

[Steve Rindsberg]

Thanks! Is it possible to chart the average and only show the occurrences in
the chart table?

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.

 

[Tushar Mehta]

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