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.

If you liked this post, why not subscribe to daily updates about presentation design via email? Just blog posts, no spam, or you can follow Jan on Twitter to never miss a thing.