I have a data set with dates used as the x-axis on a scatter chart. When Excel charts the data it includes dates on the x-axis that I haven't used in my data set. I know the trick to change the Axis Type to represent the data as a Text axis but this distorts the data. Can someone help me solve this frustrating challenge and remove the unneeded dates on my chart?
Bookmarks