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...
thanks all
max
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks