Part 2. MM4XL Tools > 3. Charts and Maps > Smart Mapping > How to Run Smart Mapping

Smart Mapping

How to Run Smart Mapping

Tip:
It's easy to get up to speed with MM4XL in a matter of seconds:

  1. select the mm4xl tool you want to work with from the toolbar.
  2. click the example button on the form. this opens an example sheet with data for the tool you are using.
  3. with your mouse, select the data sets as explained in the example sheet, then click the ok button to print the report.

Important Note:
Before launching Smart Mapping, select the sheet with a mouse-click on any cell. If a chart or a shape is selected when you launch Smart Mapping, you get an error message.

Click the Smart Mapping button in the MM4XL menu bar:

Bubble Maps Software for Scatter Plot and Circle Charts

The user form appears.

There are two tabs in the user form. The Input Data tab is where users make selections on the sheet for the relevant data ranges. The Options tab hosts controls useful to refine maps.

Input Data Tab

Bubble Maps Software for Scatter Plot and Circle Charts

When launched, the Input Data tab fields are displayed. Place the cursor in the field 1st dimension (horizontal) and using the mouse select on the sheet the data to be displayed on the X-axis of the map. Repeat this operation for the 2nd dimension (vertical), and for the 3rd dimension (bubble), the size of the bubbles.

Note:
To understand quickly how to prepare data for input to Smart Mapping, study the example file you can open from the user form by clicking on the Example button.

Use the Bubble groups (color) field to assign different colors to bubbles. This is a very useful option to visually distinguish items belonging to different groups, for example small, medium and large packages. In this field you can input any sign: number or letter. The function is case-sensitive, so a capital letter is not equal to the same letter written in lowercase. In the Output range field select a cell on the sheet where you want to print the map. In the Data labels field select the item labels to be displayed on the map. This is a very helpful option, not available for common Excel charts, which will save you a lot of work!

From the Quadrant typelist box you can choose one of four options. The Common bubble chart option creates basic charts. The remaining options offer three ways to rescale quadrants. More details on this option can be found below in the section Why and How to Re-scale Quadrants.

Tip:
To run a dynamic analysis using the field Bubble Color, input different values for the same items at two points in time. For instance, market shares of products A, B and C in 1998, and market shares for the same products in 2001. Give different labels to each item, and the products belonging to each group will be colored accordingly.

Use the Chart title box to specify a title for the chart.

Options Tab

Bubble Maps Software for Scatter Plot and Circle Charts

When all fields on the Input Data tab are filled, click on the Options tab. Here you can refine the map, as well as enhancing it with some very useful features, such as placing connecting arrows between bubbles and changing label size.

Use the Chart title 2 and Footnote text boxes to enter text that will be shown on the map. Remember that placing too much text on a map can either make it too crowded or require enlarging it significantly. Changing Label size and Color may prove useful when working with maps crowded with items. Click on the button Label Color to access the color palette.

Connecting Arrowsenables displaying of arrows between bubbles. To see an example of arrows placed on a map open the Example file using the button in the lower left area of the form. See the section Example of Sales Tendency Analysis for details on how to place arrows and how to format chart elements. The check box Remove chart axes is useful when negative values are displayed and you do not want the axis lines to display for reasons of neatness. Plot on new sheet is used to create the graph on a single sheet. Read more concerning Hide intermediary sheets in the Tip below. Click on OK when you are done and the following lines appear at the cell you selected in Output range:

Bubble Maps Software for Scatter Plot and Circle Charts

Tip:
Every time the analysis is run, a new sheet is created to store the original and normalized data. Uncheck Hide intermediary sheets on the Options tab if you are going to run the same analysis several times with only slight differences in the data. You may want to find out which display best suits your requirements, and get rid of sheets you no longer need (when option Hide intermediary sheets is checked use Format Sheet Unhide in the Excel menu and then Edit Delete Sheet).

As you click on the OK button a scatter chart like the following one appears on the sheet:

Bubble Maps Software for Scatter Plot and Circle Charts

The first dimension you select is displayed on the horizontal axis, the X-axis or abscissa. The second dimension is displayed on the ordinate axis, the Y one, and the third dimension of data is used to compute the size of each bubble. Stretching the graph in length makes it much more readable, and after a very few seconds work, will look like the example. It is very easy to modify the layout of a chart. Select each element and change it to whatever you like. To change text or position of a single label, for instance, click on it once, and all labels of one data series will be selected. Wait a second and then click again on the label, and only this one will be selected. Now, click on the label border and drag and drop it.

Here is the same chart before and after the changes:

Bubble Maps Software for Scatter Plot and Circle Charts

Finally, click on the blue QuickBuy button to access the secure server of ShareIt, our Internet sales collector, or click on the Copyright label to enter MarketingStats web site.

Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: