Excel Dashboard – Create Pie Chart

In the previous article (Create summary view portlets from Excel Data) we saw how to add a tabular portlet to the dashboard. Now we continue adding a Pie chart

Create Pie Chart (Glet)

We will convert each of the above queries into Pie chart. For a pie chart we just need two columns, the first column becomes the base on which the pie sections are named after and the second column is the numeric column that decides the pie size for each section.
Since we have three columns in all of the above queries, we will pick the first and the second column.

  • Click on the New Chart button
  • Enter the name of the Glet
  • Select the Chart Type (2d Pie or 3d Pie)
  • Enter the following query

select country_region, sum(quantity_sold) as qty_sold
from [detail_data$]
group by country_region
order by 3 desc

  • Click Apply

Image

We don't need the order by clause for a pie chart. You can select "pie" , "Pie 3d" or "Ring" from the drop down.

Here is the 3D pie version

Image

Here is the "Ring" version

Image

Similarly lets create other pie charts

By Product Category Pie chart

select prod_category, sum(quantity_sold) as qty_sold
from [detail_data$]
group by prod_category

Image

By Channel Class
select channel_class, sum(quantity_sold) as qty_sold
from [detail_data$]
group by channel_class

Image

Your dashboard should look something like this

Image

As you see the portlets are randomly placed and sized. We will take care of the placement and sizing later. Lets add few more stuff to the dashboard.

Next -> Create Bar chart from Excel Data

Join InfoCaptor and Get Free Dashboard Software

Posted in Excel | Tagged , , , , , ,


Would you like to build your dashboard now?

If so, click to buy now, including 60 minutes of dashboard development for free!