Dashboard using Excel : Create Bar Chart

In the previous article we added a pie chart (Create Pie chart from Excel Data) and now we continue adding a Bar chart

Now we add a Bar chart to our Excel Dashboard

Top Countries
select country_name, sum(quantity_sold) as qty_sold
from [detail_data$]
group by country_name
order by sum(quantity_sold) desc

Image

We select the "Chart Type = Bar", enter the query and hit "Full Apply"

The bar chart is displayed but there are few ugly things. The labels on the X-Axis are overlapping, we need proper names for the X and Y axes and what if we just need to see the "Top 5 Countries"?


Image

As you see, we changed the Max Rows=5 which limits the bar chart to top 5 countries. We changed the X Axis label = Country, Y Axis label = Quantity Sold and finally we set the x Axis label angle to 30 degrees

Lets add another bar chart by Month

By Period
select calendar_month_name, sum(quantity_sold) as qty_sold
from [detail_data$]
group by calendar_month_name

Image

Now we align and re-size the portlets
Click on Menu à Edit à Show Grid. Drag the borders of each portlet and resize them as you see fit

Image

Now that our dashboard is almost ready, we will add some parameters and make it more user friendly.

Next -> Create dashboard Parameter

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!