possible to have two Y axes and two X axes on same chart
Is it possible to have a chart with
- left Y axis
- right Y axis
- top X axis
- bottom X axis
all on same chart?
Solution 1:
If I have understand well you have two different datasets to compare on the same chart.
If so
- You can make your XY chart with both dataset.
- Then double click on one series, and on the Axis tab, select Secondary. It appears a secondary Y axis.
- Select "Chart Manu/Chart Options/Axes tab", uncheck the secondary Y box, and check the secondary X box.
