Secundary axis

%3CLINGO-SUB%20id%3D%22lingo-sub-1815724%22%20slang%3D%22en-US%22%3ESecundary%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815724%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20figure%20out%20how%20to%20combine%20two%20data%20sets%2F%20two%20graphics%20in%20one%20graphic.%20I%20tried%20to%20add%20a%20secundary%20axis%20(the%20X-axis%20is%20both%20the%20same%20in%20the%20graphics%2C%20only%20the%20Y-axis%20differs)%2C%20this%20is%20not%20possible!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EClick%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAdd%20Chart%20Element%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%26gt%3B%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAxes%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%26gt%3B%20and%20select%20between%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ESecondary%20Horizontal%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bor%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ESecond%20Vertical%20--%26gt%3B%26nbsp%3B%3C%2FSTRONG%3EI%20don't%20see%20'secondary%20horizontal%2Fvertical'.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Excel%20on%20my%20Macbook.%20From%202018.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReally%20hope%20someone%20could%20help%20me!%20(sorry%20for%20the%20bad%20English)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1815724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1815741%22%20slang%3D%22en-US%22%3ERe%3A%20Secundary%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815741%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F844930%22%20target%3D%22_blank%22%3E%40Maartjevb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20attach%20a%20sample%20workbook%20(without%20sensitive%20data)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1815743%22%20slang%3D%22de-DE%22%3ESubject%3A%20Secundary%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815743%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F844930%22%20target%3D%22_blank%22%3E%40Maartjevb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3ECreate%20a%20combination%20chart%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-combination-chart-cf2c969a-b11e-4a62-bb8f-da021177452f%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-combination-chart-cf2c969a-b11e-4a62-bb8f-da021177452f%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20some%20information%20about%20it.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EHope%20that%20the%20information%20can%20help%20you.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EI%20would%20be%20happy%20to%20get%20some%20feedback.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EHave%20a%20nice%20day%20%2F%20night.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22alt-edited%22%3EI%20know%20that%20I%20know%20nothing%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1815777%22%20slang%3D%22en-US%22%3ERe%3A%20Secundary%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815777%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BHi%20!%20Thanks%20for%20your%20fast%20respons..%20I%20can%20not%20add%20the%20data..Sorry%20for%20the%20inconvenience.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20could%20add%20a%20secondary%20axis%2C%20I%20think%20it%20would%20be%20OK%2C%20but%20it%20does%20not%20work%20out%20yet..%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@Maartjevb 

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

Highlighted

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

Highlighted

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

Highlighted

@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