Summary chart with 3 completely different data ranges

Sometimes you want to show 3 data sets in one chart with very different data ranges, for example:

• 1,000s of customers
• $ sticker price per unit
• Number of products bought per customer

One solution:

• Set the column of the first data point of each series to 100
• Calculate the 2nd value relative to the 100
• Manually paste data labels with the correct factors

The chart below gives an example:

1. The first chart contains the unadjusted data
2. The second chart shows the adjusted version
3. The third charts shows the values I have entered in the PPT columns

Click on the example image below for a larger image.