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
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
In article <[email protected]>, "=?Utf-
8?B?TGxveWQgUHJhdHQ=?=" <Lloyd [email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks