excelexcel-charts

How to align graph and the access in Excel


So I really dislike formatting in Excel. When you have a scattered plot and lines that connect the scatter how do you get the labels to align with the month labels?

This one is unaligned. enter image description here

This is aligned (note this image has been altered in an image editor) enter image description here

I have tried to edit the date for the points, such as making it all the first of the month or the end of the month, but that didn't work.


Solution

  • You can get better alignment between the tics and the data points when using the Line graphs. Scatter plots are designed to be at the measure locations. So change to line graphs.