how to plot a graph in excel based on date

Next, change the Axis Type setting, as shown in figure below. (Why you'd want to do it is another question, but someone, somewhere, is probably in desperate need of this feature.) To change how Excel scales the category axis, select the chart, and then choose Chart Tools : Layout > Axes > Axes > Primary Horizontal Axis More Primary Horizontal Axis Options to show the Format Axis dialog box. That's how the incorrect chart in figure above was created. Optionally, you have the ability to tell Excel to disregard any values you've used in your column or row labels, thereby spacing the dates out evenly, as though they're ordinary text labels. On the other hand, if you enter the labels as text (as was done when creating the bottom chart), you'll see an incorrect result: The data from August 2007 and June 2008 are placed close togethereven though they record months that are almost a year apart. (As you can see by looking at the data points, no values fall in the middle of the series.) If you take that step, the chart Excel creates automatically uses a continuous timescale, as shown in the top chart. To make sure Excel handles this omission correctly, you must enter real date values (rather than text labels) for the category axis. The twist is that a big chunk of data (the months between August 2007 and June 2008) is missing. The diamonds and triangles on the line charts indicate the data points for which sales data is available. The pictured worksheet shows two charts that illustrate the exact same data: a series of monthly sales figures from two regions (covering the time period between January 2007 and December 2008).

What's happening in fFigure above is worth examining in a bit of detail. The top chart uses category axis scaling to properly space out dates, even when there are missing values. The Five Biggest Sports Clubs In The World

How to plot a graph in excel based on date