Data Analysis of Ondo 2016 Governorship Election

It is no longer news that the good people of Ondo state had chosen their next premier citizen that will lead the Sunshine State for the next four years at least a Term in a peaceful poll conducted by INEC on the November 26th, 2016. It is imperative to take a deep look at the[…]

Shares 0

How to Create Bridge (Waterfall) Chart in Excel

This post was informed by an email received from a client who was asked to create a Bridge chart for a given data sets showing their company sales trends for the year 2015 by his boss. Bridge chart is a special type of column chart in excel that doesn’t have a built-in chart template but[…]

Shares 0

How to Insert Gantt Chart in Microsoft Excel

Gantt chart remains one of the most useful ways of showing task (events or activities) displayed against time (period). It’s commonly use in project management, scheduling production process, employee rostering, and in IT to represent already collected data. On the top of the chart is the time scales while on the left is the list[…]

Shares 0

Combo chart in excel

Combo chart contains two or more chart types in a graph. Its cool feature is how it show the interconnected data with their combined relevance. For example Romatee Motorcycle sales trends across years. To insert combo chart for this is very easy particularly in excel 2013 and beyond. Highlight the cells range Go to Insert[…]

Shares 0

How to insert Pie chart in Excel

Pie chart is use to emphasises the contribution of each category to the pie that represents grand total. This can be demonstrate with the following example showing the number staff across selected department in Nicon Hotel. To insert pie chart for the above data set. Highlight the data Go to Insert Menu Select pie chart[…]

Shares 0

Column Chart in Excel

Column chart is used for comparing values across categories. This can either be in any of the three forms, which include (1) clustered column, (2) stacked column, and (3) 100% stacked column. Clustered column is use to emphasises individual variance when order of the category is not matter. The table below shown our Dashboard Software[…]

Shares 0