Copy and Paste an Excel Chart into PowerPoint with VBA

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. 

Read More

Bubble Chart in Excel

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 particularly in the dashboard section.

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

Read More
Tags , ,