Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
5 years ago

Bar Chart Assistance Needed

I am trying to create a bar chart that shows:


each group would have 3 bars to represent Jan 2019,2020,2021 , then Feb 2019,2020,2021 etc

y axis - Count Total

------------------------------
Lynne8817 Lynne8817
------------------------------
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    You can create a formula for month which calculates to 
    " 1-Jan"
    " 2-Feb"
    etc
    "12-Dec"

    The x Axis can be the month formula above and the Series can be the YYYY.  Make a formula field for the YYYY.

    The numbering and the prefix space is to control the sort.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • LisaSell1's avatar
    LisaSell1
    Qrew Trainee
    5 years ago
    Hi Lynne,
    I have attached a screen shot of what I have done. I have a table of Invoices and I used fields Dates and Amounts. First, in your bar chart report, make a Numeric report formula (named 'month group') =Month([Date]). Use 'month group' as category label on x-axis, and group by equal values. Also note it is used for sorting low to high (so 1 =January, 2 = February, etc.). I used the  summed invoice amount as the data values on the y axis, the series is the invoice Date, grouped by year.  Hopefully you can apply this to your own chart.

    ------------------------------
    Lisa Sell
    ------------------------------