Excel Maps with Dynamic Timeline

Excel Maps with Dynamic Timeline

Excel timeline map is a map that shows location information filtered by a timeline. “Timeline map” is a coined term as it has not been shown before in Excel. A timeline is a dynamic date filter first introduced in Excel 2013. You know how to create Excel...
Create Timeline in Excel

Create Timeline in Excel

There are many ways to compose an Excel timeline, however, the method that can be reproduced more easily is the one below. The data comes from Wikipedia’s Timeline of Epidemics that resulted in 5 Million or more deaths. Excluding records with unknown numbers,...
Excel Treemap Chart in One Minute

Excel Treemap Chart in One Minute

What if there is a chart that has all the pros of a pie chart without the cons, namely its visual distortion? A square pie chart? I hear you ask. Since Excel 2016, the introduction of a hierarchical treemap chart allows you to visualise distributions just like a pie...
Automatically Rearrange Axis

Automatically Rearrange Axis

When data is not finalised just yet, we may need to update it constantly and in the process, change the appearance of any charts derived from it. How then can we update the figures and have the chart axis reorder itself either descendingly or in ascender order?...
Changing Multiple Pictures with Slicers

Changing Multiple Pictures with Slicers

This post elaborates on the method of using slicers to control the display of multiple pictures. This is necessary when one slicer is a type of category that relates to multiple fields such as the situation below for Coverage slicer: Data We will continue with the...
Change Picture by Slicer (No VBA)

Change Picture by Slicer (No VBA)

This post proposes a whole new method to extend the functionality of slicers by having pictures respond to selection change. This method applies to Excel 2016 and later. This method has not been utilised or mentioned elsewhere. Compare to the common method of...
ROI Calculator

ROI Calculator

The ROI Calculator here compares the monthly and cumulative cost difference between the existing process and a proposed process. The proposed process involves the purchasing of machinery that will result in a lower monthly cost. The timeframe for consideration spans...
Sparklines

Sparklines

Sparklines are useful to see the general trend at a glance instead of using multiple charts that take up screen asset. An important technique that works along well with sparklines is the use of relative named ranges. Workbook download Sparkline The screenshot below...
Toggle Slicer in Spreadsheet (No VBA)

Toggle Slicer in Spreadsheet (No VBA)

This is an effect that can be created for dashboard to allow more space for charts when screen size is not ideal. It adds a creative little interaction with the user without having to go into macro. The method works for both Excel and Google Sheet. Workbook download...

Pin It on Pinterest