This can be appropriate if you want to highlight a particular portion of the time series. Area Charts to Highlight One Portion of the LineĪn area chart is a line chart where the area under the line is filled with a shading or color. The middle chart in this figure shows the same data set as a line chart. When you go beyond 12 data points, it is best to switch to a line chart without individual data points.

What is the benefit over Pivot Table or simple charting? Read this article.Figure 3.2.

Why do I need Excel 2013 professional? Could I do this in older versions?.

I know you have many thoughts in your mind… Once you find the answers (Excel may not have these answers), you can manage your work more effectively.

Try doing this with your real business data and then you can not only see what happened, you will also have many questions in your mind about WHY it happened that way.

Look at the color coding and think about how customers behaved. This is how you create 12 pie charts in 1 second! Depending upon your screen size, a scroll bar may appear. Resize the Pie charts boundary so that it occupies all available space. Miracle – 12 pie charts are created instantly. Now carefully drag the Month column into the Vertical Multiples area in the field list. Yes this could have been done using Pivot Table and Pivot chart as well. Now the data is shown like a pivot table with grand totals for each investment.Ĭlick inside it and choose Other Charts – Pie Chart from the Design tab. Remove the unwanted fields – keep only Investment and Amount fields. All the data will be displayed on this Power View sheet. This sheet is just a white rectangle with a field list on the right side. If you do have Excel 2013 professional and you still do not see Power View tab, read this article for further instructions.Ī new sheet will be added. Click inside the data and choose Insert tab – Power View. Before you say “I don’t need this new thing”, have a look. Why? Because Excel 2013 (Pro Plus) gives you a new way of analyzing data called Power View. This time we are NOT going to use a Pivot Table. We want one pie chart for each month – to see how customers invested their money. The type of investment could be Bank Deposit, Real Estate or Equity.

Each row represents a transaction where a customer invested some money in some type of instrument.

How do i make a pie chart in excel 2013