+ Reply to Thread
Results 1 to 3 of 3

Stacked graph

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    4

    Stacked graph

    Hi

    Year 9
    XYZ National
    Endorsed with Excellence 42.50% 21.10%
    Endorsed with Merit 43.40% 32%
    Achieved 95% 71.40%


    Year 10
    XYZ National
    Endorsed with Excellence 38.50% 17.90%
    Endorsed with Merit 34.60% 23.90%
    Achieved 100% 79.70%

    I would like stacked graphs for the above two. I have followed instructions and drawn graphs I would like the stacked graph with 100% to be taller than the 95% achieved graph. For School XYZ- I would like the achieved, Endorsed wth excellence and endorsed with merit on one colum graph - 3 colours and copared to National. When I put year 9 and 10 beside each other the 100% is shorter than the 95% How to solve this problem


    Thanks in advance

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,564

    Re: Stacked graph

    Difficult to say much based on just the text. What have you tried? How has it worked or not worked? As I see it (see below), the short answer is that you need to find/calculate the correct numbers for the chart, then arrange those numbers in a way that makes creating the chart easy, then create your stacked bar chart.

    I find that a lot of charting questions often end up being about arranging data in the spreadsheet. Jon Peltier addresses this in this essay (https://peltiertech.com/good-chart-data/ ), which he covers in some detail. In short, if you get your data arranged in a way that Excel can easily parse categories/X values (years, I would guess in your case), values and data series (the different percentages). and series names, if needed, the chart will usually be easy to create.

    One thing to remember about stacked charts is that it adds the second series onto the value below it. This means that the data you have above (if that is the only data you have tried) is unsuitable for a stacked chart. You usually need to add a row/column that will calculate differences between values so that they stack correctly. I also cannot see how the data you show adds up to 95% for year 9 and 100% for year 10, since the sums of the percentages are not those values. I expect there needs to be some clarification to the data (which probably means some formulas somewhere) to make the data for year 9 and year 10 make "sense" to the chart engine.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    11-05-2012
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Stacked graph

    Thank you so much. The information given was easy to understand and I was able to draw the graphs pretty easily the way it was supposed to be. Thank you immensely.

+ 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. Replies: 1
    Last Post: 08-24-2016, 04:15 PM
  2. Combine Line Graph & Stacked Column Graph
    By CGreenie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2015, 12:09 PM
  3. Combining Stacked Bar Graph with Scatter Graph
    By cunningj in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-08-2014, 04:29 AM
  4. [SOLVED] Plotting a standard bar graph on the same axes as a stacked bar graph
    By Shearwater in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-01-2014, 04:59 AM
  5. [SOLVED] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  6. Creating a graph similar to a stacked column graph
    By Jonathan in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-04-2006, 11:30 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