I have a chart and its source data is read from a range which contains dates. When I plot it out into a chart, the x-axis includes dates that are not included in the range.
How do I avoid this?
For example, these are the dates:
28/04/15
27/04/15
24/04/15
23/04/15
22/04/15
21/04/15
20/04/15
17/04/15
16/04/15
15/04/15
14/04/15
13/04/15
10/04/15
09/04/15
08/04/15
07/04/15
06/04/15
02/04/15
01/04/15
31/03/15
But when the chart is plotted out, it includes dates that are not in the list, such as 05/04/15
.
05/04/15
showing up on the chart, or is it just that there is a label for that date included on the axis? 3) How is the chart being created? I see you used the [vba] tag, but it's not clear from your question how that is relevant.