+ Reply to Thread
Results 1 to 4 of 4

Chart with different sections and percentages

  1. #1
    Registered User
    Join Date
    04-03-2021
    Location
    Zaragoza
    MS-Off Ver
    2102 MICROSOFT 365
    Posts
    64

    Chart with different sections and percentages

    Hello,

    I am trying to create a chart that shows the number of total controls for the different company´s functions, the number of controls that were tested, the passed controls and the failed controls.

    I want to include in the chart of all this data I.e. 5 triangles that form the chart that are divided into number of tested controls, number of passed controls (strong controls), number of failed controls in percentage.

    Could you please help?

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,224

    Re: Chart with different sections and percentages

    Are you required to use a pie chart? I know many chart experts don't like pie charts. For something like this, they might recommend a stacked bar/column chart.

    1) Clear D5 (because Excel's chart engine really likes to have a blank upper left cell when creating a chart).
    2) Select D5:I8
    3) Insert stacked bar or column chart.
    4) Formatting as desired and evaluate the result.

    What do you think?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    04-03-2021
    Location
    Zaragoza
    MS-Off Ver
    2102 MICROSOFT 365
    Posts
    64

    Re: Chart with different sections and percentages

    Hi,

    Thank you for your help.

    Why don´t they like pie charts?

    How can I had percentages to the chart as D5:I8 does not contain them.

    Thank you in advanced

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,224

    Re: Chart with different sections and percentages

    Why don´t they like pie charts?
    You can put something like "problem with pie charts" into your favorite search engine and find many rants. Perhaps Wikipedia's treatment is representative: https://en.wikipedia.org/wiki/Pie_ch..._effectiveness

    How can I had percentages to the chart as D5:I8 does not contain them.
    If you want percentages rather than absolute values, simply choose those rows (rows 10:12) from the table instead of rows 6:8. Or, you can use absolute values for the chart and incorporate data labels that show the percentages.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create a bubble chart with sections
    By EAlden01 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-25-2020, 04:05 PM
  2. Equal sized sections on 100% stacked cone pivot chart
    By mattwally in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-02-2014, 06:22 AM
  3. Adding variable percentages to sections of a large database.
    By JohnDoh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 06:24 PM
  4. [SOLVED] Pie chart with list of components to sections
    By Tony2009 in forum Excel General
    Replies: 3
    Last Post: 08-07-2012, 10:18 AM
  5. Pie Chart using percentages
    By siexcel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-14-2009, 08:43 PM
  6. Excel chart, changing into sections to color
    By rrupp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-06-2006, 04:40 AM
  7. pie chart percentages are not right!
    By couriced in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-24-2005, 04:05 PM

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