PC Review


Reply
Thread Tools Rate Thread

Chart to report frequency of a value as a percentage of values

 
 
=?Utf-8?B?am9obm55cm92ZXI=?=
Guest
Posts: n/a
 
      26th Aug 2005
I have a column of information, I would like to create a pie chart which
outlines the number of times a value exists as a percentage of the total
number of values.

Thanks

John
 
Reply With Quote
 
 
 
 
Tushar Mehta
Guest
Posts: n/a
 
      27th Aug 2005
Check out XL's PivotTable capability. It is well suited to the kind of
analysis you want to do.

--
Regards,

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

In article <50BA1F4A-977F-475E-A221-(E-Mail Removed)>,
(E-Mail Removed) says...
> I have a column of information, I would like to create a pie chart which
> outlines the number of times a value exists as a percentage of the total
> number of values.
>
> Thanks
>
> John
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
x log, y lin audio frequency chart Jim Microsoft Excel Charting 3 27th Dec 2007 04:15 PM
Return Range of Numerical Values in Single Column based on Frequency Percentage Sam via OfficeKB.com Microsoft Excel Worksheet Functions 9 28th Oct 2005 11:01 PM
3-D Frequency Chart in VBA ptyler@tokyo.com Microsoft Excel Charting 0 5th Jul 2005 05:19 PM
frequency distribution and percentage frequency jeanne Microsoft Excel Charting 1 13th Jan 2004 07:43 PM
Frequency domain chart? tirades Microsoft Excel Charting 1 9th Dec 2003 02:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:39 PM.