PC Review


Reply
Thread Tools Rate Thread

making a chart complicated

 
 
Rene
Guest
Posts: n/a
 
      24th May 2010
I'm using Excel 2007

I have a chart that plots data points
SUMPRODUCT(--(B498:Q534>0),--(B498:Q534<=100)/COUNT(B498:Q534))
plus other formulas (between 101 and 125 etc) Formulas are in the same column


I need the chart to label the pie slice/column with

73% (83 "widgets")

73% (can do) but I haven't discovered how to add to the label the number of
times that the criteria was meet ...83 times.

Thanks for your help. I'm just a novice with excel.
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      25th May 2010
I have this data
store sales
North 25 widgets
East 82 widgets
West 34 widgets
South 45 widgets

In the second column I entered only numbers (or I could have had formulas
that generated numbers)
However, I gave these cells the custom format of: # "widgets"
Then I made a pie chart. I right clicked the chart and opened "Format data
labels" and specified show Percentages and Values. Now I see, fro example:
25 widgets, 14%
get my email from my website, send private message and I will forward a
sample file
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

REMEMBER: Microsoft is closing the newsgroups; We will all meet again at
http://answers.microsoft.com/en-us/o...ult.aspx#tab=4

"Rene" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm using Excel 2007
>
> I have a chart that plots data points
> SUMPRODUCT(--(B498:Q534>0),--(B498:Q534<=100)/COUNT(B498:Q534))
> plus other formulas (between 101 and 125 etc) Formulas are in the same
> column
>
>
> I need the chart to label the pie slice/column with
>
> 73% (83 "widgets")
>
> 73% (can do) but I haven't discovered how to add to the label the number
> of
> times that the criteria was meet ...83 times.
>
> Thanks for your help. I'm just a novice with excel.


 
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
Very complicated report to go with a very complicated query....HEL ReportTrouble Microsoft Access Reports 1 14th Apr 2009 02:02 PM
Am I making this more complicated than it has to be? =?Utf-8?B?TGF1cmlT?= Microsoft Access Queries 4 1st Aug 2007 04:46 PM
making a complicated bar graph =?Utf-8?B?aGFycnlnb3JpbGxh?= Microsoft Excel Charting 1 8th Jan 2006 05:22 PM
Am I making things too complicated? KKawahata@gmail.com Microsoft Powerpoint 2 28th Dec 2005 01:24 PM
Need help with complicated chart (xy chart? z axis? not sure!) =?Utf-8?B?UGF0aWVuY2U=?= Microsoft Excel Charting 1 5th Nov 2005 03:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:57 PM.