how to make a pie chart in excel powerview

By using a dashboard such as this one, you can quickly and easily recognize trends, do comparisons, and review performance indicators that will lead to informed decision-making.Power View in Office 2013 brings the following new features: Power view reports enhance dashboards by presenting the summarized data in one view. After you have followed the steps for installing Silverlight, in Excel, click Reload.Silverlight is a free plug-in program that enables Power View reports. On the Insert tab, in the Reports group, Select Power View, then Enable.Select the range of cells containing the data you want to visualize.N.B: The first time you insert a Power View worksheet, Microsoft Excel asks you to enable the Power View add-in if it is not installed. This will create a table with the values. In the Power View Fields, deselect all of the fields and then reselect 2014 and Department.Copy the chart and paste it next to the first one.In the Power View Fields, select only 2014 and Department.Reduce the chart to a quarter size of the screen.On the Design tab in the Other Chart list, select Pie.Copy the chart and paste it underneath the first one.

Drag the right side of the chart to fill the width of the window.Ĭreate a Pie Chart to show the 2014 sales.

With the table selected, on the Design tab in the Column Chart list, select Clustered Column.On the Insert tab, in the Reports group, select Power View.You are welcome to download the workbook to practice. Power View reports in Microsoft® Excel® pull your data together in tables, matrices, maps, and a variety of charts in an interactive view that brings your data to life.įor every visualization you want to create, you start with a table, which you then easily convert to other visualizations to find one which best illustrates your data. In this tip, we look at how to enhance dashboards with a Power View report by analyzing sales data. Dashboards can display current status of metrics and key performance indicators. Dashboards in Microsoft® Excel® are used for visually presenting important business information.

How to make a pie chart in excel powerview