Prev: Show only specific Series in the data table
Next: Where are the pivottable chart buttons?
From: Rene on 24 May 2010 16:56
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.
From: Bernard Liengme on 24 May 2010 19:54
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/office/default.aspx#tab=4

"Rene" <Rene(a)discussions.microsoft.com> wrote in message
news:37F8E77A-6F8F-4E37-9487-6E2063D6DB54(a)microsoft.com...
> 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.

 | 
Pages: 1
Prev: Show only specific Series in the data table
Next: Where are the pivottable chart buttons?