Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Create Small Multiple Line Charts in Excel?

Date:2022-5-10 Author:Sandra

Creating a line chart in Excel is easy. Just select the data area and go to the Insert tab to choose the insert line chart.

There is a worksheet of fruit prices for five months. We can get the line chart.

How To Create Small Multiple Line Charts in Excel?
How To Create Small Multiple Line Charts in Excel?

But we are going to learn another kind of line chart to show the price changes of four kinds of fruit in separate line charts.

We first need to change our fruit price table from the original to below.

How To Create Small Multiple Line Charts in Excel?
How To Create Small Multiple Line Charts in Excel?
How To Create Small Multiple Line Charts in Excel?

Then we select the area of B1:E21 to insert a line chart with markers.

How To Create Small Multiple Line Charts in Excel?

Right click on the chart and choose Select Data Source.

How To Create Small Multiple Line Charts in Excel?
How To Create Small Multiple Line Charts in Excel?
How To Create Small Multiple Line Charts in Excel?
How To Create Small Multiple Line Charts in Excel?
How To Create Small Multiple Line Charts in Excel?
How To Create Small Multiple Line Charts in Excel?

Double-click the chart area and set the interval between marks to 5. Because there are five months.

Then delete gridlines and choose Primary Major Vertical.

How To Create Small Multiple Line Charts in Excel?
How To Create Small Multiple Line Charts in Excel?

Now we got a different line chart.

How To Create Small Multiple Line Charts in Excel?
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

2 thoughts on “How To Create Small Multiple Line Charts in Excel?”

  1. maslina gam says:

    Thanks for the explanation. very easy to understand.

    1. Sandra says:

      My Pleasure

Leave a Reply

Your email address will not be published. Required fields are marked *