Results 1 to 9 of 9

Pie chart- group by cell value

Threaded View

  1. #1
    Registered User
    Join Date
    08-14-2019
    Location
    Montenegro
    MS-Off Ver
    MS Excel 365
    Posts
    9

    Pie chart- group by cell value

    Hello,


    I have multiple accounts which are billed each day with different value, it looks something like this (sorry for using Google Sheets, typing from my laptop )
    Screen Shot 2019-08-14 at 10.24.22 PM.png

    When I try to visualize this via pie chart I get the following result (as expected):
    Screen Shot 2019-08-14 at 10.29.44 PM.png

    I would like to group by the account with a similar name (in my case "ARGO") so it looks something like this:
    Screen Shot 2019-08-14 at 10.30.38 PM.png

    How can I do this automatically, I have 10000 of rows with the same pattern, any help is very appreciated.

    Thanks a lot
    Last edited by Rule; 08-14-2019 at 05:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Generate random group of words in a cell from a large group word list in column
    By faizzsheikh in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-26-2018, 10:16 AM
  2. Replies: 14
    Last Post: 01-12-2017, 01:41 PM
  3. Replies: 7
    Last Post: 06-09-2016, 09:48 PM
  4. [SOLVED] (VBA) How Assign Column Cell To Corresponding Group, and Paste Group Cells into Groups WS?
    By eryksd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-08-2016, 06:18 PM
  5. Text boxes in chart move even when I group them with chart?
    By mecexcel in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-17-2015, 10:34 AM
  6. Replies: 0
    Last Post: 10-21-2014, 03:20 PM
  7. Replies: 1
    Last Post: 02-10-2014, 10:26 PM

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