+ Reply to Thread
Results 1 to 7 of 7

Stacked Columns Squashed

  1. #1
    Registered User
    Join Date
    12-11-2019
    Location
    California
    MS-Off Ver
    365
    Posts
    14

    Stacked Columns Squashed

    Hello,

    I have created this chart and all the columns are squashed. How do I get them to expand?
    Attached Images Attached Images

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

    Re: Stacked Columns Squashed

    For some reason that the pictures cannot show, Excel is using a range of 0 to 110 for the min and max values on the vertical axis. The solution would be to change something (manually format the axis and change the limits is the first thing that comes to mind) so that the vertical axis extends from 0 to 5 or some other reasonable value(s).
    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
    12-11-2019
    Location
    California
    MS-Off Ver
    365
    Posts
    14

    Re: Stacked Columns Squashed

    Thank you! However, I need the Vertical axis to have a maximun of 110. All other values should equal 100.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,272

    Re: Stacked Columns Squashed

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,543

    Re: Stacked Columns Squashed

    I need the Vertical axis to have a maximun of 110. All other values should equal 100.
    The picture of your chart suggests that the values add up to something on the order of 1 or 2. If they should add up to 100, then I would suggest that you need to look at the spreadsheet data and debug why they aren't adding up to something like 100.

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

    Re: Stacked Columns Squashed

    If the selected cells are all in the chart, as stacked column, then the stacks should total > 200.
    Have you formatted some of the series to have no fill?
    And are all the values actual numeric? If they are being treated as text then in the chart they will be zero

    As AliGW suggests post example file
    Cheers
    Andy
    www.andypope.info

  7. #7
    Registered User
    Join Date
    12-11-2019
    Location
    California
    MS-Off Ver
    365
    Posts
    14

    Re: Stacked Columns Squashed

    Thanks everyone! To fix this issue I changed the style of chart form 100% Stacked Column to Stacked Column. Once I changed it the columns popped up their correct places. Thank you again for your help!

+ 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] 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
  2. How to prevent a large scatter graph being squashed?
    By jj007 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-01-2013, 02:52 PM
  3. [SOLVED] Squashed Calendar
    By dank_01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2012, 07:26 PM
  4. Excel 2007 : Spreadsheets are 'squashed' when opening
    By intermarine in forum Excel General
    Replies: 4
    Last Post: 05-14-2010, 11:04 AM
  5. squashed test in combobox
    By Conor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2006, 04:30 PM
  6. squashed test in combobox???
    By Conor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2006, 04:20 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