Pie Chart Help

Posted on 2011-10-10
Last Modified: 2012-06-21
I need to create a pie chart showing how many NO and Yes per ID and per CAT
Thus for ID C, it will show two slices - one NO and one YES; and the same per CAT.

I attached a copy of my data.

Thank you in advance.
Question by:squirrelzan

    Author Comment

    Here is the attachement.

    LVL 59

    Accepted Solution


    Did you looked into the option of creating pivot pie chart. Enclosed is the one for your reference. Please change your filters and accordingly pivot charts will get changed.

    LVL 2

    Assisted Solution

    Hello squirrelzan,

    I also used a pivotchart. But I formatted you data differently before creating the chart. I concantinated the three pieces of information together prior to building the chart. Please see the attached.

    Best of luck

    Author Comment

    Both ways of doing them work... Never thought of doing pivot charts and guess that was where I was going wrong.

    Thank you for all your help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Title # Comments Views Activity
    stop word moving down 2 24
    Min Month 11 29
    Check version 13 25
    simple formula but cannot get it work. 5 19
    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    This collection of functions covers all the normal rounding methods of just about any numeric value.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now