Hello,
Say I have the following series, USA, Canada, Europe and Asia.
And on each series, I have the year 2015 and 2016.
Due to the big in numbers of one of the series, the other small numbers can't be seen.
Thus, am wondering is there a way to make a specific series, i.e. Europe and Asia for the data in 2015 and 2016 onto a secondary axis?
Below are the screenshot of the 'original' and 'desired'
using big numbers.png
BEFORE - notice the big numbers, the other's can't be seen.
Using small numbers.png
AFTER - I desired that the 'Europe' and 'Asia' to be in a secondary axis so that the big numbers are together and the small numbers are together.
However, please take note that I cheated when creating this chart with small numbers so as to show what I desire the outcome to be.
Bookmarks