Category Archives: Macros

How to make a picture transparent – Macro

In an earlier article, I had shown a method of making a picture transparent using the Transparency animation. This method shows the transparency only while PRESENTING – not while EDITING. Here is a macro which will help you create a transparent copy of any picture which is transparent during editing as well.

transparent image macro

Continue reading How to make a picture transparent – Macro

Macro to Explode Pivot table by Filter Field Items

Refer to the previous post. We saw how Filter fields can be exploded into individual sheets and files. In this article, I am releasing a macro – which does all the hard work for you. Of course, you must use it at your own risk. The source code is also included for you to view, learn from and modify. Created by Raj Chaudhuri and myself.

PivotFilterExplode macro

Photo credit: Johnson Cameraface / Foter / CC BY-NC-SA

Continue reading Macro to Explode Pivot table by Filter Field Items

New Excel Tool: Scribble a line and generate data (and chart)

This is a utility I created along with Raj Chaudhuri many years back.Use the scribble tool to draw a waveform or shape, the utility will create the data for it.

Excel scribble tool

You can then create a line chart which looks similar to original drawing.
Try it out.

Continue reading New Excel Tool: Scribble a line and generate data (and chart)