+ Reply to Thread
Results 1 to 3 of 3

Populating Chart From Dropdown Choice

  1. #1
    Registered User
    Join Date
    10-26-2010
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Populating Chart From Dropdown Choice

    Hi, I am attempting to build a chart based on 3 options of a drop-down list i have created.
    the drop-down consists of:

    N/A
    In Progress
    Complete

    Mainly the information i want to chart is %ages of the above 3 options according to about 40 rows of this drop-down.

    so for example N/A 20% In Progress 30% Complete 50%

    i have been messing with axis labels and data pull selections for a few hours now with no luck, and no luck on Google =/

    Any links or direct help is appreciated, thank you!

  2. #2
    Valued Forum Contributor
    Join Date
    10-17-2010
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013, 2016, 2019, 365
    Posts
    294

    Re: Populating Chart From Dropdown Choice

    Unless I misunderstand, you could use COUNTIF to count how many of each appears, then a simply divide this by the total of all three to get the %s, and generate the chart from these 3 bits of data.

  3. #3
    Registered User
    Join Date
    10-26-2010
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Populating Chart From Dropdown Choice

    Quote Originally Posted by outofthehat View Post
    Unless I misunderstand, you could use COUNTIF to count how many of each appears, then a simply divide this by the total of all three to get the %s, and generate the chart from these 3 bits of data.
    Thank you! This is perfect, got it working with no issues!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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