+ Reply to Thread
Results 1 to 3 of 3

Display largest revenue contributors on bar chart?

  1. #1
    Registered User
    Join Date
    06-23-2021
    Location
    Oceanside, CA
    MS-Off Ver
    365
    Posts
    10

    Question Display largest revenue contributors on bar chart?

    I have a bunch of data with "groups" that have customers and revenue received from each of those customers.

    I want to be able to sum those groups and display each of their revenue in a bar graph (easy enough) but I also want to display the biggest customer for each group somewhere on the graph, perhaps in the axis names as in the dummy example attached. I want to be able to do this in Power Query, as that is how I'm currently combining all of my real data, but I'm not really sure how to do this. I'm also not sure how to google search for a solution because I don't really know what this would be called. How do I group by the "group" column, sum up the revenue, and also create a column that shows the biggest customer for each group?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-09-2021
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    148

    Re: Display largest revenue contributors on bar chart?

    Hi,

    Mayb enot the most elegant solution... and not using power query...

    But maybe something that'll work in the meantime...
    Attached Files Attached Files

  3. #3
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,966

    Re: Display largest revenue contributors on bar chart?

    Here's one way using PQ. I'm sure it could be streamlined a lot!
    Attached Files Attached Files
    Everyone who confuses correlation and causation ends up dead.

+ 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. chart - revenue for the month
    By robbie88 in forum Excel General
    Replies: 6
    Last Post: 08-08-2016, 04:14 AM
  2. [SOLVED] Create a column chart by month with three separate contributors?
    By brucemc777 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-05-2016, 08:35 PM
  3. [SOLVED] Find largest value and display in a textbox
    By chin67326 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2016, 11:16 PM
  4. Replies: 1
    Last Post: 02-03-2015, 06:16 AM
  5. [SOLVED] Formula to Display Valid Revenue Daily
    By SamuelMRoth in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2013, 04:22 AM
  6. Revenue chart
    By themr in forum Excel General
    Replies: 1
    Last Post: 12-04-2011, 02:27 PM
  7. Total revenue by month in a chart
    By pentatonic145 in forum Excel General
    Replies: 0
    Last Post: 01-21-2008, 02:35 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