+ Reply to Thread
Results 1 to 5 of 5

Stuck, Stacked Clustered Column Chart

  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    Des Moines, Iowa
    MS-Off Ver
    Office 365
    Posts
    43

    Stuck, Stacked Clustered Column Chart

    This is very simple, but I can't figure it out. All that I am wanting to do is have one column that shows both the value of the estimate and the value of actual. What the chart is doing is showing me a % of the total which is what I don't want, nor care. I have tried to figure out by watching videos etc, but can't figure out how to make a chart that only has 2 values of estimated and actual in one single column chart.

    Thanks,
    Attached Files Attached Files
    Last edited by tonym33; 04-22-2020 at 09:53 AM.

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

    Re: Stuck, Stacked Clustered Column Chart

    I don't see in the example file what you are describing.

    You have stacked column charts, where the Estimated hours are stacked on top of Actual hours. There is no % data being shown or used.

    Are you wanting a chart where you can more easily compare actual to estimate? If so try changing the chart to cluster column rather than stacked.
    If not perhaps mention the chart type the videos you watched where trying to create, or provide a link so we can see.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-15-2019
    Location
    Des Moines, Iowa
    MS-Off Ver
    Office 365
    Posts
    43

    Re: Stuck, Stacked Clustered Column Chart

    Andy,
    All the charts in the file are the examples. If you look at the first one the Estimated amount is 49,625, but the chart is showing going up to 80,000 because it's adding the estimated amount of 49,625 and the actual amount of 31,194. I was hoping to have a chart that maxed out at lets say 50,000 because the estimate is below this and then the column inside of the other column would show the actual amount of 31,194 and would grow as the actual amount keeps going up. In all of the charts they are adding the estimated and the actual and just displaying how much that amount is in relation to the total of the two.

    Tony

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

    Re: Stuck, Stacked Clustered Column Chart

    Confused by you request to have 1 column, which is what you had.

    Change chart to cluster column
    Select Actual series and move to secondary axis
    Delete secondary axis
    Set primary vertical axis to auto
    select Estimate series and reduce gap width

    You should now have red column infront of wider blue column.

    Position data labels so you can easily tell with is which.

    See first chart in attached
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-15-2019
    Location
    Des Moines, Iowa
    MS-Off Ver
    Office 365
    Posts
    43

    Re: Stuck, Stacked Clustered Column Chart

    Andy,
    TY you so much. I have been trying to figure this out for over 2 days.

    Thanks again,

+ 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. Stacked clustered column chart
    By jpmoglia in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-14-2017, 09:58 PM
  2. How to make a clustered column stacked bar chart?
    By Jumana Nooruddin in forum Excel General
    Replies: 1
    Last Post: 11-11-2014, 09:41 AM
  3. [SOLVED] Clustered and Stacked column in the same chart
    By bryan444 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-16-2013, 10:03 AM
  4. Clustered-stacked column chart in Excel 2007?
    By bmurata in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-10-2010, 06:49 PM
  5. Clustered and Stacked Column Chart
    By superkid in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-19-2009, 09:54 AM
  6. [SOLVED] Combined: Clustered-Stacked Column Chart
    By cdo in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-30-2005, 09:05 PM
  7. Clustered column chart with stacked coumns
    By Dave in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-04-2005, 07:06 PM

Tags for this Thread

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