+ Reply to Thread
Results 1 to 2 of 2

Need pie chart with number of fields instead of info in fields

  1. #1
    Lloyd Pratt
    Guest

    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. #2
    Tushar Mehta
    Guest

    Re: Need pie chart with number of fields instead of info in fields

    In article <A884151F-07D1-4A93-9C65-ED1112E601F6@microsoft.com>, "=?Utf-
    8?B?TGxveWQgUHJhdHQ=?=" <Lloyd Pratt@discussions.microsoft.com> 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1