I have a column that puts the date for new leads that come in on my dashboard. I am trying to put a chart together where the X axis is the number of leads generated by month and the Y access is the count. I am using the line chart. Is there a way for me to make the X axis JUST the 12 months of the year (not May 2020, June 2022, … November 2022, December 2022 etc.) and then put multiple lines on the chart (one color for each year) so it is possible to see leads generated in May 2020, May 2021, May 2022, etc. all stacked in the May column by count?
Not sure if that makes sense but it would be awesome and way more helpful than a chart with 50 months one after another.