Author: melih

Centered Stacked Bar Chart

If you need to compare 2 data series, stacked bar chart might be just what you need. You can of course insert a stack bar...

Interactive Production KPI Dashboard

Here is a nice Interactive Production KPI Dashboard that shows various KPI’s side by side for different company locations for easy comparison. It is also...

Word Cloud Generator

Seeing word clouds (or tag clouds) in dashboards and web sites quite often, I decided to make one myself using Excel VBA. It is a...

Excel Shortcuts Presentation

Here is an Excel Shortcuts Presentation that I prepared for a training session I conducted. You can grab some useful shortcuts from these slides.

Positive Negative Bar Chart

Here is a nice bar chart that clearly shows how multiple units does compared to each other based on same criteria. Since this chart can...

Excel Timeline

Excel Timeline is a new pivot table filter introduced in Excel 2013. It automatically evaluates date data and provides year, quarter, month and day filters...