+ Reply to Thread
Results 1 to 3 of 3

Bar charts \ stacked and columns

  1. #1
    Registered User
    Join Date
    Minneapolis, MN
    MS-Off Ver
    MS Office 2010

    Bar charts \ stacked and columns

    I am unfamiliar with how these charts can operate. Is it possible to have a bar chart with bars that are columns and then also stacked inside the same chart? See the attached. What I would like to do is this:
    In 'Sales & Actual Cost' Chart, I would like 'Budgeted Cost' and 'Additional Cost' to be a stacked column.
    The other issue I can't seem to figure out is why the 'Combo Chart' isn't working. I want to be able to combine 'Gross Margin %' with 'Original vs. Adjusted Gross Margin' charts. Am I selecting the data incorrectly?
    Is it possible to do a refresh of a chart or change the way in which the data is displayed? Do I need to manually move the order in which the data lays in the excel sheet? Meaning, I want the Original Gross Margin' to be on top and the 'Adjusted Gross Margin' to be on bottom because the 'Original Gross Margin' amount is greater than 'Adjusted Gross Margin'.

    I am new to utilizing bar charts so any guidance is much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.

    Re: Bar charts \ stacked and columns

    One way for the stacked column chart is to make the Budgeted and Additional Cost a single series.

    For the GM use some formulae to force the higher value to be the second one shown.

    See attached.
    Attached Files Attached Files
    Richard Buttrey

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

  3. #3
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007

    Re: Bar charts \ stacked and columns

    In 'Sales & Actual Cost' Chart, I would like 'Budgeted Cost' and 'Additional Cost' to be a stacked column.
    Rearrange the data in the spreadsheet so you can put additional cost into its own data series and change the chart type to a stacked column chart:
    1) chart data table:
    Please Login or Register  to view this content.
    2) Select these 6 cells and insert a stacked column chart. Then format chart elements as desired.

    I wasn't sure exactly what you wanted to do in combining the gross margin % and original vs adjusted gross margin charts. As a guess, it looks like you want to somehow communicate both the gross margin values and the % margin values in the same chart. Starting with the "Original vs. Adjusted Gross Margin" chart, I:
    1) Change the chart type to 2D stacked column (because I hate trying to read 3D charts -- see this essay for why: https://peltiertech.com/the-perils-of-being-in-3d/ )
    2) Delete the current data labels (I will read the gross margin values directly off the chart).
    3) Using Rob Bovey's free XY chart labeler add-in (your profile says you are using Excel 2010, so this functionality is not native to our versions of Excel) and use the values in B7 and B8 as the data labels for each data series.
    4) Using the Select source data dialog, change the plot order of the two data series (to the right of the "Remove" button in the Legend Entries (Series) portion of the dialog is a pair of up/down arrows which you can use to move a series up or down in the plot order).

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

+ 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. Need non-overlapping Stacked Column charts in pivot charts
    By chand173 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-13-2018, 02:08 PM
  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 charts
    By JonathanB2 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-14-2014, 01:09 PM
  4. column charts: stacked / non stacked hybrid ??
    By littlejimmy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-24-2012, 11:36 AM
  5. Stacked Bar Charts
    By MCofman in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-16-2010, 10:32 AM
  6. [SOLVED] creating stacked charts with two comparative columns
    By birchbark in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-20-2005, 11:15 AM
  7. [SOLVED] Stacked Pie Charts
    By Athalie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-28-2005, 01:06 AM


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