Perceptual mapping is a key analytical tool in understanding market positioning. While the best piece of software to use to construct a perceptual map is Microsoft Excel, the structuring of the graph is sometimes a little bit tricky.
Either a bubble chart for a scatter chart is the most appropriate chart type in Microsoft Excel to produce a perceptual map, but unless you know some of the intimate details of setting up the data series, the perceptual map does not create as nicely as required in professional business reports.
The following video highlights how to make it perceptual map, using Microsoft Excel on a step-by-step basis.
How to make a perceptual map using Microsoft Excel
Video on using a perceptual map template for Microsoft Excel