You have a simple sales report, year as a dimension and sales as value.

When you select insert – chart – insert line or area chart, both sales and year are shown as lines. Even though only sales is reported here, year is a value in x axis.

The graph does not look good.

You can activate the year line and delete it.

The year line disappears but the values in x axis remain.

Activate the graph, select design – select data.

Remove the year in legend entries, and press edit in horizontal (category) axis labels.

Select the year values as Axis label range.

Press ok.

Now the graph looks good.

However, a faster way exists also to have a proper graph.

Delete the word “year” in B3.

Activate the data area, take insert – charts – insert line or area chart.

The graph is automatically as it should be.