Chart legend doesn't match chart

[Robert Hames]

I have created a report using the time series column type. The chart is displaying the data correctly, but the legend doesn't match the chart. The y-axis is "Average Days To Complete", and the x-axis is set to trend by month.

The legend is being generated by the chart, and it is wrong. (see snapshot below) For example, the June 2021 iis showing 6.79 days, which is correct, but the color depicts that it is > 2 months. Any suggestions/ideas?

[Jaspal Singh]

No. That is OOB report range stauts. What do you mean you want it to be shown by month or duration is not what you expect?

[Robert Hames]

My goal for the report is to group all the projects that were completed for a given month, get the average number of days it took to complete those projects by dividing the total number of days it took to complete those projects by the number of projects, and display that on the bar for that month in the chart.

So, if they completed 25 projects in March of 2021, and it took them 676 days to complete those projects, I would like the bar for March of 2021 to show 27.04.