Secundary axis

Copper Contributor

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

@Maartjevb 

Could you attach a sample workbook (without sensitive data)?

@Maartjevb 

 

 

Create a combination chart

https://support.microsoft.com/en-us/office/create-a-combination-chart-cf2c969a-b11e-4a62-bb8f-da0211...

 

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)

@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.. 

@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.

Screenshot 2020-10-25 at 12.50.27.png

Screenshot 2020-10-25 at 12.59.29.png