+ Reply to Thread
Results 1 to 2 of 2

Stacked Bar Chart with horizontal axis as dates

  1. #1
    Registered User
    Join Date
    01-31-2017
    Location
    Washington
    MS-Off Ver
    2011
    Posts
    1

    Stacked Bar Chart with horizontal axis as dates

    I'm using Excel Mac 2011.

    I created a stacked bar chart as a Gantt chart. The vertical (category) axis is 20 Tasks entered as text. The horizontal (value) axis values are the dates spread over 2.5 years. They are in date format in the spreadsheet.

    On the chart I want the horizontal axis scale to be Dates with an indication at the start of each month, i.e. J, F, M, etc. When I go to Format Axis, the horizontal axis scale is Auto (numbers) and I can’t change it to Dates.

    As a work around I selected Major unit as 30 and formatted Number as Date > "M". The "months" are not spaced properly since months do not have same number of days. You will see J J M A M M etc.

    I saw a similar posting on another forum but there was no fix.

    Thanks for your help
    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,803

    Re: Stacked Bar Chart with horizontal axis as dates

    This tutorial talks about how to do that: http://peltiertech.com/Excel/Charts/GanttChart.html Basically, you create a combination stacked bar + line chart. The stacked bar creates the gantt chart, and the line chart provides the nice horizontal date axis.
    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. [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. Axis for Horizontal Stacked Bar Chart with multiple date
    By sa02000 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-10-2017, 07:42 AM
  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. [SOLVED] Stacked Horizontal Bar Chart / Help with Dates
    By Ciwan in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 10-11-2013, 08:23 AM
  5. Replies: 1
    Last Post: 11-28-2012, 01:17 PM
  6. [SOLVED] Dates on Horizontal Axis Cross Chart Area Border
    By Gnokrojam in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-22-2011, 12:01 PM
  7. Excel 2007 : Excel 2007 chart horizontal axis dates
    By xanthippie in forum Excel General
    Replies: 2
    Last Post: 11-07-2009, 08:24 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