I want to combine two properties which are related to each other in one figure. For that I need 2 vertical axis, one on the right side of the figure, and other on the left side. Did anyone one know how to do that? Both axis would have different numbers and units.
https://www.youtube.com/watch?v=_ZLfvogWX_A
https://www.youtube.com/watch?v=OB1J7DV4ovs
In Excel you simply produce your chart and then right click on the data series you want to show on a second axis and then choose "format data series" and "secondary axis".
If you only want to show one line, then use dummy data and set the line colour to "no color"
only oossible if atleast one series is line chart. select the series and right click>format series>axis>secondary axis.
First off all plot all the data series in excel. Now right click on the data series you want to move to secondary axis and select "format data series". Select secondary axis.
- Badges
- Science topic