+ Reply to Thread
Results 1 to 4 of 4

Sorting columns into multiple columns for bar chart

  1. #1
    Registered User
    Join Date
    02-09-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Sorting columns into multiple columns for bar chart

    Hi. I have a single column of data. It is a baseball roster, a list of player names. They come from multiple towns and and a range of ages.

    Column A. Player name.
    Column B. Player town.
    Column C. Player age.

    i.e.:

    Joe. Chicago. 12
    Jim. Chicago. 12
    John. Chicago. 14
    James. Chicago. 14
    Adam. New York. 12
    Andy. New York. 12
    Alex. New York. 14
    Arthur. New York. 14

    I want to do a stacked chart that shows the total player count by age for each town. The x axis would have one stacked column for Chicago (12: 2 count, 14: 2 count), and one stacked column for New York (12: 2 count, 14: 2 count).

    How do I sort/split and subtotal the one column out to make this chart? Thanks.

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    1,754

    Re: Sorting columns into multiple columns for bar chart

    You need to have your cities on a row in columns B and C and your range of ages listed in the left most column of the chart data source range. Then the counts of each age bracket would go under the appropriate city.

    HTML Code: 
    Age	Chi	NY
    12	2	4
    14	6	5
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, click the 'Go Advanced' button, Then click 'Manage Attachements' and follow the menu.
    Thinking I am smart and knowing I am smart are two entirely different levels of schizophrenia.

  3. #3
    Registered User
    Join Date
    02-09-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Sorting columns into multiple columns for bar chart

    Quote Originally Posted by JLGWhiz View Post
    You need to have your cities on a row in columns B and C and your range of ages listed in the left most column of the chart data source range. [/HTML]
    Thank you. I should have said I was looking for either
    (1) a way to do the chart from one column of data
    or (2) an easy way to break the one column into multiple columns, in order to do the chart as you described above

    I gave up and break the data out the hard way

  4. #4
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    1,754

    Re: Sorting columns into multiple columns for bar chart

    You could use 'Text To Columns' to put the three elements into separate columns.

+ 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