+ Reply to Thread
Results 1 to 2 of 2

show in a excel graphic a total percentage for 5 diff data fiels

  1. #1
    Julio
    Guest

    show in a excel graphic a total percentage for 5 diff data fiels

    I need to make a graphic showing the percentage for 5 diff fields, e.i. pmc
    total 16, nmcs total 10, pmcs total 5, nmcm total 0, and nmcs total 3, this
    it should be based on a total of 100% combine. at this tiem I can't figure
    out the formula how to make read all 5 columns, please help.
    If need it I can forward the project file to make better sense of it.

    Thank you.

    Julio

  2. #2
    Tushar Mehta
    Guest

    Re: show in a excel graphic a total percentage for 5 diff data fiels

    Select the 5 fields and create a pie chart. The size of each slice
    depends on the % value of that data item compared to the total.

    I don't understand the 2nd bit about "formula to make read all 5
    columns."

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > I need to make a graphic showing the percentage for 5 diff fields, e.i. pmc
    > total 16, nmcs total 10, pmcs total 5, nmcm total 0, and nmcs total 3, this
    > it should be based on a total of 100% combine. at this tiem I can't figure
    > out the formula how to make read all 5 columns, please help.
    > If need it I can forward the project file to make better sense of it.
    >
    > Thank you.
    >
    > Julio
    >


+ 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