+ Reply to Thread
Results 1 to 6 of 6

Dynamic Stacked Chart

  1. #1
    Registered User
    Join Date
    05-03-2013
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    61

    Dynamic Stacked Chart

    Hello

    Ive attached an example data set and pivot Ive created and my requirement/vision is to have a Bar chart which shows a single column per TYPE ie 4 bars. Each record however has a type and status and my aspiration is to have a stacked bar for each type split by status and ideally a data label per status.

    Is this possible and if so how? I hope Im being clear ie Id expect to see 4 bars but each bar would have its own colour key and then show stacked colours based on the statuses of records of that type.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,436

    Re: Dynamic Stacked Chart

    I think I understand, but I am not sure. Here's what I tried -- see if this is what you are looking for:

    1) In the pivot table pane, I moved status from Row Labels to column labels. This gave me what I assume is the desired stacked column chart.
    2) To add the data labels, I selected the chart, clicked on Layout -> Data Labels -> Center.
    2a) Excel defaults to "values" for the data labels. I selected each set of data labels -> Format data labels -> deselect values and select series name.

    Is that what you are looking for?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Dynamic Stacked Chart

    Mr Shorty's solution is the way to go given you've already got a PT.

    The attached is one alternative using a data table layout.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    05-03-2013
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    61

    Re: Dynamic Stacked Chart

    Im just about to try both solutions now so fingers crossed, however thanks in advance

  5. #5
    Registered User
    Join Date
    05-03-2013
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    61

    Re: Dynamic Stacked Chart

    MrShorty exactly what Im after. I suspected I just needed to layout the pivot differently and you confirmed this, cheers.

    Is there a quick way to Format all data labels in one go as Im having to right click each individually?

    Part of me in thinking I might get away with simply changing the chart layout to Quick layout 5 and combining table type data with chart but not quite as ****

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,436

    Re: Dynamic Stacked Chart

    Is there a quick way to Format all data labels in one go as Im having to right click each individually?
    Note that I am aware of. If you know a little VBA, it would be possible to write a macro that would loop through each data series and change the data label text. I find that, even though it is tedious, it is generally easier and faster (at least if this is a one time or rare task) to do it manually.

+ 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] Create a dynamic stacked bar chart and remove blank rows
    By sav1979 in forum Excel General
    Replies: 3
    Last Post: 03-21-2016, 01:12 PM
  2. dynamic Stacked 100% column Chart
    By bglick in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 01-23-2014, 04:34 PM
  3. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  4. Dynamic chart not working with stacked column
    By simonzxr in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-27-2012, 08:09 AM
  5. Dynamic Stacked Column Chart
    By adelkam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-09-2012, 04:34 AM
  6. Dynamic Stacked Column chart
    By coa01gsb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-25-2008, 08:34 PM
  7. Dynamic Stacked Column Chart Help
    By ksp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-19-2006, 08:15 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