+ Reply to Thread
Results 1 to 4 of 4

Bars not pulling through the correct date ranges on combo chart

  1. #1
    Registered User
    Join Date
    01-24-2020
    Location
    London, UK
    MS-Off Ver
    office 365
    Posts
    4

    Bars not pulling through the correct date ranges on combo chart

    Dear All

    I have created a combo chart in a Gantt type format to illustrate deliverables as bars within predefined date ranges. This issue is that the bars do not accurately reflect the date ranges assigned so a deliverable that is supposed to start in April and end in June for example, is showing a completely different range. I have checked formulas etc and cannot seem to figure out the issue. I have attached if anyone can easily figure out how to resolve this problem.




    Many thanks
    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: Bars not pulling through the correct date ranges on combo chart

    When I looked over your chart, I found that all of the stacked bar (Gantt) series were defined to cover rows 33 to 57 -- except for the very first stacked bar (base starting date) series which was defined to cover rows 34 through 57. This causes the base starting date for each category to be off by one category's starting date, which causes every other stacked bar to be off. By editing series one (Date Range series) so that it includes row 33 (F33:F57), I was able to get the bars to cover what I assume are the correct dates.

    Another edit I made (mostly for my own benefit, but you may also find it beneficial). I formatted the horizontal axis so that it would show both month and date. When I see a month-year date like your file originally showed, I want to assume that the gridline corresponds to the first of said month. However, in your chart with a major unit of 35 days, it is obvious that each gridline does not correspond to the first of each month. By using a number format that includes both month and day, I found it easier to read the date range for each bar of the Gantt chart.
    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
    01-24-2020
    Location
    London, UK
    MS-Off Ver
    office 365
    Posts
    4

    Re: Bars not pulling through the correct date ranges on combo chart

    Hi

    Thank you so much for taking the time to look at this for me. I don't suppose you saved a copy of the version you edited and if so could you attach it?

    All the best
    Sophie

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

    Re: Bars not pulling through the correct date ranges on combo chart

    I did not save it, but I also only made two simple edits.
    1) Editing row number for Date Range series -- Select the series -> F2 (to enter edit mode) -> navigate to the $F$34 part -> change 34 to 33.
    2) Formatting the axis -- Select the horizontal axis -> Format axis -> Number -> choose a format that shows both month and day from the available date formats.

+ 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] No space between bars on chart and non-squiggly lines in texture of bars
    By dianaCatz in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-05-2019, 04:37 AM
  2. Data pulling from Combo box is for a specific date, not a Month rollup
    By SouthernAngel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2018, 02:37 PM
  3. Replies: 15
    Last Post: 11-25-2014, 08:14 AM
  4. Replies: 2
    Last Post: 10-30-2014, 05:48 PM
  5. Replies: 1
    Last Post: 06-20-2006, 08:45 AM
  6. How do I get the date correct in excel 2000 on a chart?
    By Racheb in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-16-2005, 01:15 AM
  7. Bar Chart Date XAxis Thin Bars
    By MrC in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-14-2005, 11:06 PM

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