Oct 25 2020 02:42 AM
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)
Oct 25 2020 02:50 AM
Could you attach a sample workbook (without sensitive data)?
Oct 25 2020 02:51 AM
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)
Oct 25 2020 02:58 AM
@Hans Vogelaar 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..
Oct 25 2020 05:01 AM
@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.