+ Reply to Thread
Results 1 to 3 of 3

Raw data to Custom data in to Stacked Bar chart (Combined Y-axis | workbook attached)

  1. #1
    Registered User
    Join Date
    06-23-2022
    Location
    Texas, US
    MS-Off Ver
    365 Enterprise | v2205
    Posts
    2

    Lightbulb Raw data to Custom data in to Stacked Bar chart (Combined Y-axis | workbook attached)

    I'll describe the problem a little bit: So, I have a raw data source where all the users and people, who work on that sheet enter and like modify the data.
    What I have been assigned with is that:

    • There are a few sheets which are named by the companies [which is a column in the data].
    • Each of these sheets are formatted in a certain way where the first column is kind of merged [see the image/workbook for more reference, if you don't get it, ping me]
    • My superior has requested a stacked bar chart where the products on the Y-Axis are clustered into the categories they fall into according to the various tiers. So, like T1 can have C1, C2 type and all T1 should appear first. [Again descriptive in the workbook]

    The major problem lies whenever someone "adds a row somewhere in between". In that case, all the process has to be done manually, AGAIN & AGAIN like creating the data and making the chart.
    I am stuck at the point where I want to automate the fact that whenever someone adds a row it automatically goes into the correct subcategory in the table and merge or whatever but the chart gets updated in the same fashion.


    Any help?
    Let me know if you have any questions.
    Attached Files Attached Files
    Last edited by xkillerbabax; 08-18-2022 at 01:59 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,472

    Re: Raw data to Custom data in to Stacked Bar chart (Combined Y-axis | workbook attached)

    Try using a pivot table and chart.

    When new data is added to raw data you simple need to refresh.
    I added a slicer for Company selection, but you could use the field dropdown on the chart
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-23-2022
    Location
    Texas, US
    MS-Off Ver
    365 Enterprise | v2205
    Posts
    2

    Re: Raw data to Custom data in to Stacked Bar chart (Combined Y-axis | workbook attached)

    Quote Originally Posted by Andy Pope View Post
    Try using a pivot table and chart.

    When new data is added to raw data you simple need to refresh.
    I added a slicer for Company selection, but you could use the field dropdown on the chart
    That was some lit solution, man! Perfect and thank you so much!

+ 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. [SOLVED] Creating custom data label on stacked column chart
    By BirdtheYounger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2020, 04:30 PM
  2. Stacked column chart with data below x axis
    By SarahC83 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-09-2018, 03:11 AM
  3. [SOLVED] Excluding #na data on horizontal axis in stacked chart
    By groitblat in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-18-2014, 11:17 PM
  4. Stacked columns chart - use non-numerical data in the vertical axis
    By guillermo_A in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-01-2014, 09:35 AM
  5. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  6. Trying to create a stacked column chart with data above and below the x-axis
    By funkmeister79 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-24-2013, 10:54 AM
  7. Replies: 2
    Last Post: 09-22-2005, 06:57 AM

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