How Excel draws a simple line chart

How Excel draws a simple line chart

This is a chart using the same set of data sources, and the visual effects of the two should not be more than I say. Next, let's look at how to achieve it.

Step 1

First select any cell in the table-Insert tab-line chart-a line chart with data markers.

Step 2

Select the date axis, right-click--Format axis

In the Format Axis dialog box that pops up, set the axis major tick-mark type to none.

Click on the number-custom, enter "M/d" in the format code, click Add--Close

Step 3