+ Reply to Thread
Results 1 to 3 of 3

Multiple Data in one column

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2016
    Posts
    48

    Multiple Data in one column

    Hi folks,

    Charts really are not my strong point on Excel. So I do hope someone can help.

    I have data - 43 different reasons for something to be incorrect. I also have 8 branches who can get the items wrong.

    Is there a way to get a chart (column is fine) to show for instance, Reason 1 errors in a single column, but have the column split to show how many of those total errors were for each branch?

  2. #2
    Registered User
    Join Date
    10-09-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2016
    Posts
    48

    Re: Multiple Data in one column

    Just answered my own question. :D

    Stacked Columns. Now how do I get it to display the series names

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Multiple Data in one column

    If I understand correctly, point five of the linked article may help.
    https://www.dummies.com/software/mic...in-excel-2007/
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Merging Multiple Sheet's column of data based on other column's cell value
    By BALA1983 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2017, 12:32 AM
  2. Merge specific column data from multiple sheets in single column of new workbook.
    By kadam203 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2016, 01:58 AM
  3. [SOLVED] Convert column B as multiple column titles and move data in column C into new columns?
    By princesscathryn in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-30-2014, 07:31 PM
  4. Replies: 4
    Last Post: 06-08-2012, 03:24 PM
  5. Replies: 5
    Last Post: 02-07-2012, 04:55 PM
  6. Replies: 2
    Last Post: 11-28-2011, 06:10 PM
  7. Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Columns
    By nzxt1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 01:17 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