how to make a pie chart in excel with multiple columns

One Line Chart per Country (Country is placed in VERTICAL MULTIPLES area). You will observe the following in the above visualization − Hence, the visualization that you have is the Vertical Multiples visualization. A Line Charts appear in a grid with each Line Chart representing a Country.Ĭlick on Grid Height in the Multiples group.Ĭlick on Grid Width in the Multiples group.Īs you are aware, you have placed the Country field in the VERTICAL MULTIPLES area in the Power View Fields pane. In the Power View Fields pane, Year is in AXIS area and Medal Count is in ∑ VALUES area.Ĭreate Multiples visualization with Line Charts as follows −ĭrag the field Country to VERTICAL MULTIPLES area in the Power View Fields pane.

In the Line chart, Year is on X-axis and Medal Count Values are on Y-axis. A Line Chart appears with Medal Count by Year. Start with a Table with fields – Year and Country.Ĭonvert the Table to Line Chart. Suppose you want to display the Medal Count by Year for each Country. You can arrange the Multiples either horizontally or vertically. You can have Line Charts, Bar Charts, Column Charts, and Pie Charts as Multiples. You can arrange Multiples side by side, to compare many different values easily at the same time. Multiples, also called Trellis Charts are a series of Charts with identical X and Y axes.

How to make a pie chart in excel with multiple columns