+ Reply to Thread
Results 1 to 5 of 5

Bar or Pie Graph that automatically counts unit (cells)?

  1. #1
    Registered User
    Join Date
    03-15-2014
    Location
    Nashville, TN
    MS-Off Ver
    365
    Posts
    33

    Bar or Pie Graph that automatically counts unit (cells)?

    Guys; see the attached file....I'm trying to create a graph that will chart the number of items that are duplicated in the list. For example, if there are six entries that all say "MA 14-15 Pops 2+ STBs", I'd like that to be charted in a bar graph. If eight entries say "14/15 Referral - NSO Staff" that would be another element of the chart.

    All I could think of was "sumif" or "countif" but that would be too onerous. If I trim the first characters out, and then sort them, of course, I'll be able to see them in their groups and maybe that would be a start....

    Any help would be appreciated. Thanks so much.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Bar or Pie Graph that automatically counts unit (cells)?

    Make a chart of a pivot table
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    03-15-2014
    Location
    Nashville, TN
    MS-Off Ver
    365
    Posts
    33

    Re: Bar or Pie Graph that automatically counts unit (cells)?

    Looks awesome. Thanks so much.

  4. #4
    Registered User
    Join Date
    03-15-2014
    Location
    Nashville, TN
    MS-Off Ver
    365
    Posts
    33

    Re: Bar or Pie Graph that automatically counts unit (cells)?

    How did you do that? How did you get that "count of source descr" column in the pivot table?

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Bar or Pie Graph that automatically counts unit (cells)?

    that is also column A
    Last edited by popipipo; 12-17-2014 at 04:46 PM.

+ 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. Finding Total For Individuals By Monthly Tab and Unit Counts
    By mydragonstalents in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2013, 02:25 PM
  2. Replies: 1
    Last Post: 06-10-2012, 08:57 AM
  3. Automatically adding a unit price
    By Toolman John in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-20-2009, 09:36 PM
  4. [SOLVED] how can I program my graph to use degrees as it's unit?
    By snickers in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-17-2006, 09:25 AM
  5. [SOLVED] Changing the scale major unit in a graph
    By Ant in forum Excel General
    Replies: 2
    Last Post: 02-06-2006, 09:45 AM

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