displaying only months and year on the x axis

liv.hagen

I am trying edit the first chart so that the x axis is only displaying the month and year (so the axis is less crowded) but all the underlying points pulled from the created date are still displayed. I'm pulling the data from the report shown and have tried to make a helper column that shows the month and year, but this column is a text/number and not a date column (that's the only way I could figure out how to achieve this). Therefore, when I try to graph this and use the first column as series labels, it cant display it how I'm trying and the last graph shown is the output. Is there a way to achieve only displaying the month and year on the x axis while keeping all the underlying data points?

Hollie Green

I would try the below for your Month Label column it will make it show as Dec-22 etc. you will have to complete the formula with the rest of the months. Below formula thanks to @Paul Newcome

=IF(MONTH([Column Name]@row) = 1, "Jan", IF(MONTH([Column Name]@row) = 2, "Feb", IF(MONTH([Column Name]@row) = 3, "Mar", .............................)))))))))))) + "-" + RIGHT(YEAR([Column name]@row), 2)

liv.hagen

@Hollie Green This doesn't seem to solve my issue

Hollie Green

Is the formula not working or is it doing something different weird with the chart? @liv.hagen