chartsmicrosoft excelmicrosoft-excel-2007microsoft-excel-2010
I have created a line graph based on dates and the values associated with those dates. However, it is inserting dates into a graph which I do not want. The dates run in chronological order, I only want the graph to display weekday dates whereas the graph actually inserts the weekend dates which are not in my data. Can anybody help?
I made a three line comparison graph by selecting all of the data as a block i.e. the X axis and the three Y axis data points. I then used the same Insert > Line > 2D line.
The chart popped up as desired.
I don't know if it made a difference but I had the data arranged in columns with headings, i.e.
Column A - X axis
Column B - Data set 1
Column C - Data set 2
Column D - Data set 3
Another alternative is to use an Excel Scatter plot, which lets you choose different sets of time (X) values for each data set plotted:
Best Answer
You have two options if you don't like Excel's default assumption that you want your line chart to show "in between" dates where you have no specific data points.
Option 1 - show them as blanks
If you add the weekend dates into your data, but leave the values blank, your chart does this. This might be what you're looking for.
Option 2 - skip the dates like they don't exist
Right-click the date axis. Select
Text axisunderAxis Type:. This will treat your dates as any other label - it could just as well be: "18/11/14","red","20/11/14","blue". It just treats it as text instead of a date, meaning your weekend dates aren't shown.