Skip to main content
Question

Bar Chart Assistance Needed

  • February 25, 2021
  • 0 replies
  • 19 views
Forum|alt.badge.img+11
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
  • LisaSell1
  • Registered
  • February 26, 2021
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
------------------------------
Terms & ConditionsAccessibility statement