displaying only months and year on the x axis

Options

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?

Answers