LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default Creating Chart and calculating data

On Tue, 29 Jul 2008, in microsoft.public.excel.charting,
John2008 said:
I've been trying to establish an equation in the chart setup wizard to
add the scores based on auditor name and divide it by the number of
instances to come up with the average score.


Don't use the chart wizard to calculate averages, use the spreadsheet.
Then use the chart wizard to display the results.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating data from a chart Sarah0824 Charts and Charting in Excel 3 May 14th 08 03:52 AM
Creating a chart of text data Shellteach Excel Discussion (Misc queries) 2 August 6th 07 04:30 PM
Creating data for a chart DavidS Charts and Charting in Excel 4 December 2nd 06 06:31 PM
Creating Chart from Two Rows of Data [email protected] Excel Discussion (Misc queries) 3 September 8th 06 08:09 AM
How To Refresh Chart Data Without Calculating The Worksheet Carl Bowman Charts and Charting in Excel 5 January 19th 05 09:28 PM


All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"