Hi Connie, 

An idea, but one that would take work to implement, is to use a JS chart library like Chart JS. I was able to add some charts in a form based on table values. There are different JS chart libraries you could use. ChartJS has some nice bar charts that I think could do what you need. 

Sample of a Chart I added to a form's "report" page:

• added custom HTML block
• Added CSS to HTML block (control size)
• In my case, created a query in sql db, used a lookup rule to add the results to a table. 
• Javascript:

  • //pie chart js CDN
    $(document).ready(function(){
    	$.getScript('https://cdn.jsdelivr.net/npm/chart.js@3.8.0/dist/chart.min.js', function(){
          var activeCount =  $('.statusCountTbl tbody tr:nth-child(1)').find('.col2 input').val();
          var inactiveNonExecCount = $('.statusCountTbl tbody tr:nth-child(2)').find('.col2 input').val();
          var inactiveCompleteCount = $('.statusCountTbl tbody tr:nth-child(3)').find('.col2 input').val();
          var pendingCount= $('.statusCountTbl tbody tr:nth-child(4)').find('.col2 input').val();
          var blankCount = $('.statusCountTbl tbody tr:nth-child(5)').find('.col2 input').val();
          
          
          const ctx = document.getElementById('myChart');
          const myChart = new Chart(ctx, {
            type: 'pie',
            data: {
              labels: ['Active', 'Inactive Non Executed', 'Inactive Complete', 'Pending', 'Blank'],
              datasets: [{
                label: 'Status Count',
                data: [activeCount, inactiveNonExecCount, inactiveCompleteCount, pendingCount, blankCount],
                backgroundColor: [
                    'rgba(255, 99, 132, 0.2)',
                    'rgba(54, 162, 235, 0.2)',
                    'rgba(255, 206, 86, 0.2)',
                    'rgba(75, 192, 192, 0.2)',
                    'rgba(153, 102, 255, 0.2)',
                    'rgba(255, 159, 64, 0.2)'
                ],
    
                hoverOffset: 4
              }]
            },
            options: {
              plugins: {
                title: {
                  display: true,
                  text: 'Contracts by Status'
                }, 
              }
            }
          });
        });
    });
    

     

Tons of information on the ChartsJS website that explain how to use their library. Another option: echarts.apache.org.

Hope this helps