Results 1 to 4 of 4
  1. #1
    jschneiter is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    10

    Modern Chart vs Classic Chart

    So I cant decide between using my Classic Bar chart or the new Modern Bar Chart.



    Category access = 2007, 2008, 2009 up to 2020
    Primary Axis = 1, 2, 3, 4, 5

    Classic Chart
    If there is a year with no data, it will skip it on the axis. So it wont show empty years
    2007, 2008, 2010, 2011, 2012, 2015 instead of consecutive 2007-2020

    Modern chart
    Will show the empty missing years (2007-2020), but the Y axis (Left Side), you don't have the ability to control the scale.
    So I need whole numbers 1 - 5
    Instead of 1,2,3,4,5 .... it will be 1, 1.5, 2, 2.5, 3, 3.5, 4, 4.5, 5

    Summary
    I really like the look of the Classic as I can make it look however I want. But the deal break is it skipping in-between years.
    The Modern looks really nice as well, but the .5 increments are a deal breaker.

    Based on these two issues, which would you choose?
    If you have resolutions to either of these issues, I would love to hear them as well.

    Thanks!

  2. #2
    jschneiter is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    10
    Anyone have any suggestions?

    My Category X Axis is years 2007-2019

    I really like the Modern as it includes empty years (years with no data) but it has some weird cosmetic issues
    The Classic looks awesome but skips empty years.(years with no data)

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Can force all years in classic graph by either

    1) joining to a dataset of all store/year pairs
    Build a table with one field of year values.
    As shown in your other thread, build CROSSTAB query.
    Build Cartesian query to create store/year pairs (assuming there is a Tbl_Stores): SELECT Years.Yr, Tbl_Stores.StoreID FROM Years, Tbl_Stores;
    Build chart RowSource SQL: SELECT YrSt.Yr, Query1.Pass, Query1.Fail FROM YrSt LEFT JOIN Query1 ON (YrSt.Yr = Query1.Yr) AND (YrSt.StoreID = Query1.CC_Store) WHERE (((YrSt.StoreID)=[tbxStore]));

    Instead of CROSSTAB, could emulate it with a regular aggregate query and the graph RowSource could be one long nested query:
    SELECT YrSt.Yr, P, F
    FROM (SELECT Yr, StoreID FROM Years, Tbl_Stores) AS YrSt
    LEFT JOIN (SELECT Year([CC_Date]) AS Yr, Tbl_CChecks.CC_Store, Count(IIf([CC_SalesOutcome]="Pass","Pass",Null)) AS P, Count(IIf([CC_SalesOutcome]="Fail","Fail",Null)) AS F
    FROM Tbl_CChecks
    GROUP BY Year([CC_Date]), Tbl_CChecks.CC_Store) AS Q1 ON (YrSt.Yr = Q1.Yr) AND (YrSt.StoreID = Q1.CC_Store) WHERE YrSt.StoreID=[tbxStore];

    or

    2) if chart RowSource is a CROSSTAB query with pivot on year value, using IN() clause.
    Last edited by June7; 04-05-2021 at 03:47 PM.
    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.

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

Similar Threads

  1. Replies: 4
    Last Post: 10-24-2020, 02:16 PM
  2. Replies: 4
    Last Post: 05-11-2020, 10:42 PM
  3. Replies: 5
    Last Post: 05-10-2017, 02:38 PM
  4. Replies: 1
    Last Post: 10-22-2012, 07:04 PM
  5. Replies: 2
    Last Post: 07-12-2010, 05:39 AM

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