+ Reply to Thread
Results 1 to 2 of 2

Pareto chart with stacked columns

  1. #1
    Registered User
    Join Date
    01-31-2020
    Location
    Tampere
    MS-Off Ver
    2019
    Posts
    1

    Pareto chart with stacked columns

    Hello

    I would like to make a combination chart of pareto chart with stacked columns. However, im somehow unable to do it. Im only able to do separate charts.
    Attached an example file which is similar to the actual file im using. File has Pareto chart and Stacked column chart. So basically I would want to have both of these visual informations in same chart.

    Thank you a lot for help
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,663

    Re: Pareto chart with stacked columns

    Here's how I'd set it up.

    1. Add Percentage column
    =SUM($B$2:$D2)/SUM($B$2:$D$4)
    Copy down.

    2. Select A1:D4 and create stacked column chart.

    3. Select A2:A4, hit CTRL and select E2:E4 range. Insert line chart.

    4. Copy the line chart, select chart area of stacked column and paste.

    5. Previous step would likely make all series into line. So change chart type, and set A, B, C to stacked column, and series 1 to line with secondary axis checked.

    See attached sample.

    Note: You can't do this using Histogram/Pareto that's in the template (as histogram by design groups data into buckets and does not use stacked category).

    EDIT: Oh I forgot to mention I first used sum(b2:d2) to sort largest to smallest.
    Attached Files Attached Files
    Last edited by CK76; 01-31-2020 at 10:43 AM.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

+ 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. Merge values in 2 columns to specify to axis in Pareto chart
    By kar_coepm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-17-2019, 08:58 AM
  2. [SOLVED] Combine stacked columns and stacked bars in a chart
    By maboho93 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-09-2018, 07:52 AM
  3. Stacked Column Chart AND pareto
    By LewisGoose in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-27-2016, 11:56 AM
  4. Replies: 2
    Last Post: 10-25-2013, 10:22 AM
  5. Stacked and Solid Columns in one chart
    By OZManager in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-28-2012, 07:35 AM
  6. How do I have stacked columns and a reg col. on same chart?
    By Kat in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-14-2006, 05:10 PM
  7. [SOLVED] Create stacked columns chart but with 2 columns for each x axis?
    By PSM in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-07-2005, 11:06 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