how to chart an average of data within datasheet

F

Felix

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

Felix

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

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
 
Top