+ Reply to Thread
Results 1 to 2 of 2

Create bar chart with total amount and counting individuals

  1. #1
    Registered User
    Join Date
    03-16-2017
    Location
    Brazil
    MS-Off Ver
    2010
    Posts
    1

    Create bar chart with total amount and counting individuals

    I have a table, in each row of it there are three columns: a column with the name of someone; a column with your net worth value; a column with the city in which the person lives. I want a bar graph in which each bar represents the total net worth per city and the label must contain the net worth total amount and the number of people in the city. How can I make this?

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

    Re: Create bar chart with total amount and counting individuals

    I'm sure there are different approaches.

    The first thing to recognize is that Excel charts do not really analyze data for us. This means that, if you want a chart that shows the total net worth for each city, then the first thing you need to do is compute the net worth for each city. One approach would use a SUMIF() or SUMIFS() function https://support.office.com/en-us/art...6-611cebce642b. Another approach would use a pivot table. http://www.excel-easy.com/data-analy...ot-tables.html In order to get the number of people in each city, you can use a COUNTIF() or COUNTIFS() function https://support.office.com/en-us/art...c-aa8c2a866842 , or add a count column to your pivot table. Then build your chart from that information. Exactly how to build the chart may depend on which approach you take to get the summary data, so let's get that far.

    What help do you need to get the summary data in the spreadsheet?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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 individuals' Timetables from Schedule of Global Data
    By hokkaido19 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 03-10-2016, 04:20 AM
  2. Replies: 2
    Last Post: 12-24-2015, 02:30 PM
  3. Replies: 2
    Last Post: 05-05-2015, 05:13 AM
  4. 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
  5. Need to chart both amount and percentage from a cell as total
    By Taiter in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-25-2013, 09:50 AM
  6. Replies: 1
    Last Post: 03-27-2013, 12:22 PM
  7. Counting values to create a unique total
    By mclarenman2 in forum Excel General
    Replies: 7
    Last Post: 11-05-2008, 05:28 PM

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