+ Reply to Thread
Results 1 to 3 of 3

Stacked Bar chart date issue

  1. #1
    Registered User
    Join Date
    02-21-2017
    Location
    CA
    MS-Off Ver
    2016
    Posts
    2

    Stacked Bar chart date issue

    I'm using a project mgmt excel dashboard which included a stacked bar chart. The template had dates from 2015, I"m using it for project which has dates from 2017 on. The chart still "thinks" it needs to show on the axis 2015 dates which makes the gannt chart inaccurate . However the data source does not have any 2015 tasks. I tried different things but looks to me like a bug or something.

    I have attached a sample

    Please advise how to fix the gantt chart that pulls data from the notes table

    Thanks a lot!

    Peter

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

    Re: Stacked Bar chart date issue

    The horizontal axis is formatted with a fixed minimum at 42249 (the serial number for september 2 2015). You should be able to simply change this number to something more in line with what you want (42949 would be the serial number for August 2, 2017).
    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
    02-21-2017
    Location
    CA
    MS-Off Ver
    2016
    Posts
    2

    Re: Stacked Bar chart date issue

    awesome, that did it! Thanks so much!

+ 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. 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
  2. Stacked data points on a chart with the same date
    By zavalney in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-21-2015, 03:44 AM
  3. Issue with updating stacked bar with date
    By conlie in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-05-2015, 04:59 PM
  4. [SOLVED] Waterfall + stacked bar chart Excel issue
    By jw01 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-22-2015, 03:38 PM
  5. Stacked Area Chart Taper on/off issue
    By tonykslee in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 04-30-2014, 10:45 AM
  6. Diverging Stacked Bar Chart issue
    By Lis7 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 06-23-2013, 07:00 PM
  7. How to use multiple date fields in a stacked bar chart
    By sowmyanath in forum Excel General
    Replies: 1
    Last Post: 04-20-2009, 04:05 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