If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I have a chart but the months keep repeating at the bottom. I know it's a simple fix but I can't seem to find the right answer. I have attached a sample file. I just want the month to show up just once on the x axis...
Because the chart is a xy-scatter, which is plotted the date value rather than real dates.
If you change the number format to include days you will see that the repeat is due to 2 dates being included within the scale Major step value, which is 20.
Use Line chart type with Time series x axis. Set scale to be Month based.
Linear Mode
