The Tennis Chart

• July 18, 2019
• Marcus Small

I happened across this article on the Brisbane Times website which outlined the dominance of Federer, Nadal and Djokovic in recent memory. This article outlines how the interesting chart is created in Excel.

Copy and Paste an Excel Chart into PowerPoint with VBA

• December 22, 2015
• Marcus Small

Creating Powerpoint presentations automatically is handy if you want the power to control another office application.  In this post I will copy a chart in Excel and paste it into a fresh instance of Power Point.  I will show two examples, once where the data will be pasted into a presentation with a title and one without.   This is a building blocks approach, creating a procedure which pastes one chart might seem like time better spent done manually but if there were 20 charts it would be faster for VBA to do the work for you. 

Bubble Chart in Excel

• March 26, 2015
• Marcus Small

Creating Bubble charts in Excel is reasonably straight forward.  They are very similar to a line chart without the line and with a bit more pizazas.  You will find quite a few Bubble Charts onthesmallman.com particularly in the dashboard section.

The following article will take you through how to make one.