Results 1 to 3 of 3
  1. #1
    hemantsogani is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    18

    Controlling the extent and divisions on the X-Axis of a Chart


    I am plotting Weekly Numbers for a year. The X-Axis has the week of the year. To compare plots for different birds, I want to ensure that the X-Axis covers the whole year. I could not see how to do it through the Properties. I had to add extra records (Bird XXX) to include the first and last week of the year. Is there any other way to do it?

    I would also like to make divisions of either 4 weeks (approximate a month) or 13 weeks (approximate a season). Currently the markings are at 10 weeks. I would also like to have the columns in different colors for each division for better impact. Is it possible?

    The charts for a Bird can be generated by entering the name (American Robin, American Crow or American Goldfinch) in the form Bird and clicking on the button.
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,818
    There are no charts in this db.

    Textbox on Bird form should be a combobox with RowSource like: SELECT DISTINCT Bird FROM BirdsHome;
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I'm not sure what exactly you are seeking.

    I looked at your database. I created a query to separate the observation based on quarter.
    where month1-3 Q1, 4-6
    Q2, 7-9 Q3 and 10-12 Q4.

    Code:
    SELECT birdshome.Bird
        ,IIf(Month(ObservationDate) BETWEEN 10
                AND 12
                    ,"Q4"
                    ,IIf(Month(ObservationDate) BETWEEN 7
                            AND 9
                                ,"Q3"
                                ,IIf(Month(ObservationDate) BETWEEN 4
                                        AND 6
                                            ,"Q2"
                                            ,"Q1"))) AS Expr1
        ,Count(birdshome.NumberSighted) AS CountOfNumberSighted
    FROM birdshome
    GROUP BY birdshome.Bird
        ,IIf(Month(ObservationDate) BETWEEN 10
                AND 12
                    ,"Q4"
                    ,IIf(Month(ObservationDate) BETWEEN 7
                            AND 9
                                ,"Q3"
                                ,IIf(Month(ObservationDate) BETWEEN 4
                                        AND 6
                                            ,"Q2"
                                            ,"Q1")))
    ORDER BY birdshome.Bird
        ,IIf(Month(ObservationDate) BETWEEN 10
                AND 12
                    ,"Q4"
                    ,IIf(Month(ObservationDate) BETWEEN 7
                            AND 9
                                ,"Q3"
                                ,IIf(Month(ObservationDate) BETWEEN 4
                                        AND 6
                                            ,"Q2"
                                            ,"Q1")));
    Result for Bird Sightings by Quarter
    (it might give you some ideas; you could use a query to get values by Month, etc.
    Others more familiar with charts may have other suggestions)

    Bird Expr1 CountOfNumberSighted
    American Crow Q1 18
    American Crow Q2 12
    American Crow Q3 6
    American Crow Q4 22
    American Goldfinch Q2 7
    American Goldfinch Q3 42
    American Robin Q1 17
    American Robin Q2 77
    American Robin Q3 85
    American Robin Q4 41
    XXX Q1 0
    XXX Q4 0

    Good luck with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Chart Axis decimal places
    By scotte16 in forum Access
    Replies: 2
    Last Post: 06-19-2019, 03:21 PM
  2. Chart Y Axis Whole Integers
    By james28 in forum Reports
    Replies: 3
    Last Post: 08-21-2014, 12:31 PM
  3. Replies: 13
    Last Post: 06-10-2014, 06:19 AM
  4. Formatting Chart Axis
    By kab16 in forum Access
    Replies: 2
    Last Post: 06-05-2014, 11:13 AM
  5. Scaling a Chart Axis
    By Paul H in forum Reports
    Replies: 5
    Last Post: 10-16-2013, 01:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums