Forum Discussion
Secundary axis
Hi there,
I am trying to figure out how to combine two data sets/ two graphics in one graphic. I tried to add a secundary axis (the X-axis is both the same in the graphics, only the Y-axis differs), this is not possible!
Click Add Chart Element > Axes > and select between Secondary Horizontal or Second Vertical --> I don't see 'secondary horizontal/vertical'.
I have Excel on my Macbook. From 2018.
Really hope someone could help me! (sorry for the bad English)
4 Replies
Create a combination chart
Here is some information about it. Hope that the information can help you.
I would be happy to get some feedback.
Have a nice day / night.
Nikolino
I know that I know nothing (Socrates)Could you attach a sample workbook (without sensitive data)?
HansVogelaar Hi ! Thanks for your fast respons.. I can not add the data..Sorry for the inconvenience.
If I could add a secondary axis, I think it would be OK, but it does not work out yet..
Maartjevb On an MB, two-finger-click (track pad) or right-click (mouse) on the data series you want to plot on the secondary axis and select "Format Data Series..." and select "Secondary Axis" button. See pictures below.
