FAQ: How to add a second Y axis on my chart?

Sometimes, data are so different that displaying them on one graph does not look nice because one set of date is HUGE and the other almost invisible.

Here an example: this shows the distance travelled and the speed of a falling object.

The distances is increasing exponentially but the speed increases constantly.

one axis chart

This would look much better with a second Y axis. Like this:

second y axis

This result is achieved by:

First click on the points you want in the second axis.

second axis select

Then Select FORMAT DATA SERIES which will open the window on the side to give you the following menu. By selecting secondary axis, automatically, the series you have selected becomes the secondary axis.

secondary axis

You just need to format and add titles to your axis in order to get a beautiful result.