+ Reply to Thread
Results 1 to 3 of 3

Axis for Horizontal Stacked Bar Chart with multiple date

  1. #1
    Forum Contributor
    Join Date
    10-03-2005
    Posts
    185

    Axis for Horizontal Stacked Bar Chart with multiple date

    I am trying to create a horizontal Stacked Bar chart with multiple dates to show various stages of each project. I have created the chart that I want on attached excel but I can't get the x-axis to align and display correctly. Does anyone have a trick to display x-axis dates correctly?

    Thank you in advance,
    Jay

    Disclaimer/Credit: I started attached file from Peltiertech which got me this far to a clean chart!! Thank you.
    Attached Files Attached Files

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

    Re: Axis for Horizontal Stacked Bar Chart with multiple date

    I think the thing that you are missing is an understanding of how stacked bar/column/line charts work. The first series is charted its value to the right of the x axis. The second series is plotted its value above the end of the first series, and so on. So, as you have it set up, the chart is plotting the first bar 42000+ days, then adding and additional 42000+ days to get the second bar, and so on.

    What you need is the differences calculated in the spreadsheet. I would probably proceed as follows:

    1) In G2, enter =B2. copy down
    2) In H2, enter =C2-B2 copy H2 down and across.
    3) Adjust series in chart so that chart is based on G2:J2 instead of B2:E2.
    4) Adjust data labels to reflect the dates, as desired, or remove the data labels. If you are using 2013 or later, the option to select cell data for data labels is built into Excel. If you are using a version earlier than 2013, you will want to download Rob Bovey's XY chart labeler add-in to get this functionality.

    Where do you get stuck?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    10-03-2005
    Posts
    185

    Re: Axis for Horizontal Stacked Bar Chart with multiple date

    That worked. I did try taking the difference earlier but this time worked lot better.

    Thank you.
    Jay
    Last edited by sa02000; 01-10-2017 at 07:47 AM. Reason: Trying to mark it as solved.

+ 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] Dates by Month on X-Axis in Horizontal Stacked Bar Chart
    By Bandolier2k in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-16-2018, 11:02 PM
  2. Stacked Chart - Change Bar Colors Based on Date (X-Axis)
    By JazzLover in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-10-2015, 12:12 PM
  3. [SOLVED] Excluding #na data on horizontal axis in stacked chart
    By groitblat in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-18-2014, 11:17 PM
  4. Stacked Bar graph with two horizontal axis??
    By jschneiter2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-15-2013, 12:56 AM
  5. How to Set Horizontal Axis to Time date in Bar chart
    By jpa1234 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-31-2013, 10:35 AM
  6. Stacked bar chart with stacked secondary axis markers - please help!
    By Boardlady in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-22-2013, 10:32 AM
  7. Replies: 1
    Last Post: 05-30-2013, 10:03 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