View Single Post
  #1  
Old May 24th, 2010, 09:56 PM posted to microsoft.public.excel.charting
Rene
external usenet poster
 
Posts: 140
Default making a chart complicated

I'm using Excel 2007

I have a chart that plots data points
SUMPRODUCT(--(B498:Q5340),--(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.