| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Need pie chart with number of fields instead of info in fields
I need to create a pie chart based on an excel sheet, but I dont want the
info. in the fields calculated. I want to chart the number of fields per employee |
|
#2
|
|||
|
|||
|
In article , "=?Utf-
8?B?TGxveWQgUHJhdHQ=?=" <Lloyd says... I need to create a pie chart based on an excel sheet, but I dont want the info. in the fields calculated. I want to chart the number of fields per employee Have you looked at a PivotTable (and associated PivotChart)? It supports a Count capability. Alternatively, check XL help for COUNTIF and similar functions. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| variable chart color by number value | Charts and Charting in Excel | |||
| A Buggy Chart | Charts and Charting in Excel | |||
| Excel2000: Weird chart behaviour | Excel Discussion (Misc queries) | |||
| Pivot Chart - default chart type | Excel Discussion (Misc queries) | |||
| Pie chart on a pie chart (exploded)? | Excel Discussion (Misc queries) | |||
Hybrid Mode
