LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 74
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.
 
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
Complicated chart, not sure how to finish it! jinfanti Charts and Charting in Excel 1 September 3rd 08 09:30 AM
Making formula too complicated? Bernie R. Excel Worksheet Functions 3 March 13th 08 12:22 AM
making a complicated bar graph harrygorilla Charts and Charting in Excel 1 January 8th 06 04:22 PM
Complicated Stacked Bar Chart? Don Cardoza Charts and Charting in Excel 1 December 10th 05 05:14 PM
Need help with complicated chart (xy chart? z axis? not sure!) Patience Charts and Charting in Excel 1 November 5th 05 02:24 PM


All times are GMT +1. The time now is 10:38 AM.

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"