Access chart starts with too early a start date

Discussion in 'Microsoft Access Forms' started by M Skabialka, Apr 14, 2010.

  1. M Skabialka

    M Skabialka Guest

    I have created a horizontal stacked bar chart on a form in Access 2007,
    where the horizontal axis is a date. The start date covers the length the
    first part of the bar, and the stacked part is the number of days to add to
    it, so essentailly it shows a date range.
    The dates that I am testing with go from Mar - Aug 2010, but the chart
    starts at Dec 09. How can I make it pick up the earliest date in my query
    as the date to start the chart with, other than going into chart design and
    forcing a minimum value on the horizontal axis scale?

    e.g. the huge gap before 1 Mar shows up:

    TASK1 | 1 Mar XXXXXXX
    TASK2 | 5 Apr XXX
    TASK3 | 8
    Jul XXXXXXXXXXX
    ------------------------------------------------------------------------------------
    Dec Jan Feb Mar Apr May Jun Jul Aug Sep|
     
    M Skabialka, Apr 14, 2010
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Gary Nelson

    Start Date / End Date

    Gary Nelson, Jul 28, 2003, in forum: Microsoft Access Forms
    Replies:
    3
    Views:
    193
    John Vinson
    Jul 28, 2003
  2. Dave Elliott

    When Access First Starts, NO MACRO, just code. ?????

    Dave Elliott, Aug 28, 2003, in forum: Microsoft Access Forms
    Replies:
    2
    Views:
    156
    Dave Elliott
    Aug 28, 2003
  3. AimeeK

    Make sure end date is one year greater than start date

    AimeeK, Nov 11, 2005, in forum: Microsoft Access Forms
    Replies:
    8
    Views:
    325
    John Vinson
    Nov 15, 2005
  4. FA
    Replies:
    3
    Views:
    248
  5. Downie

    Form Start Date to default to Table Start Date

    Downie, Apr 7, 2006, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    170
Loading...

Share This Page