I have an excel 2010 graph. The x axis has 21 dates in consecutive order followed by seven weekending dates.
The graph keeps the values close for the consecutive days, but when the week ending dates display, there is a wide gap, as if it was taking the missing dates into consideration.
I am trying to bring the week ending dates close together, as the consecutive dates dispaly.
Any help will be appreciated.