Chart with two set of data X and Y

[00alex00]

Hello,

I am trying to recreate a scatter chart that has two set of value, one on the X and one on the Y.

When I am trying to do that I get always two set of data one on the Y and one parallel using the secondary axis



While I would like to get this:



Thank you in advance.

I don't know if change something but I run excel on a mac.

 

[thisoldman]

Try selecting the right-hand vertical axis with your mouse and then using the right-click menu to delete that axis. That should force the data to use the left-hand axis.

 

[00alex00]

Try selecting the right-hand vertical axis with your mouse and then using the right-click menu to delete that axis. That should force the data to use the left-hand axis.

Thank you thisoldman,

I have tried but when I delete the right-hand vertical axis it brings everything on the left one.

 

[thisoldman]

Can you post the data? It's difficult to tell what is going wrong for you without the data layout.

 

[00alex00]

Can you post the data? It's difficult to tell what is going wrong for you without the data layout.

Sure,

[TABLE="width: 376"]
<tbody>[TR]
[TD]Banca[/TD]
[TD]Op Mgn % 5y Avg[/TD]
[TD]P/B[/TD]
[/TR]
[TR]
[TD]HSBC Holdings[/TD]
[TD="align: right"]23.5[/TD]
[TD="align: right"]1.09[/TD]
[/TR]
[TR]
[TD]Banco Santander SA[/TD]
[TD="align: right"]15.7[/TD]
[TD="align: right"]0.99[/TD]
[/TR]
[TR]
[TD]BNP Paribas SA[/TD]
[TD="align: right"]10.9[/TD]
[TD="align: right"]0.8[/TD]
[/TR]
[TR]
[TD]ING Groep NV[/TD]
[TD="align: right"]27.8[/TD]
[TD="align: right"]1.2[/TD]
[/TR]
[TR]
[TD]Lloyds Banking[/TD]
[TD="align: right"]4.16[/TD]
[TD="align: right"]0.97[/TD]
[/TR]
[TR]
[TD]Banco Bilbao Vizcaya Argentarià[/TD]
[TD="align: right"]11.8[/TD]
[TD="align: right"]1.06[/TD]
[/TR]
[TR]
[TD]Nordea Bank AB[/TD]
[TD="align: right"]41.2[/TD]
[TD="align: right"]1.57[/TD]
[/TR]
[TR]
[TD]Intesa Sanpaolo SpA[/TD]
[TD="align: right"]5.51[/TD]
[TD="align: right"]1.49[/TD]
[/TR]
[TR]
[TD]Credit Agricole SA[/TD]
[TD="align: right"]5.28[/TD]
[TD="align: right"]0.71[/TD]
[/TR]
[TR]
[TD]Barclays[/TD]
[TD="align: right"]7.29[/TD]
[TD="align: right"]0.55[/TD]
[/TR]
[TR]
[TD]Societe Generale[/TD]
[TD="align: right"]6.27[/TD]
[TD="align: right"]0.63[/TD]
[/TR]
[TR]
[TD]UniCredit SpA[/TD]
[TD="align: right"]-19[/TD]
[TD="align: right"]0.97[/TD]
[/TR]
[TR]
[TD]Royal Bank of Scotland[/TD]
[TD="align: right"]-20.9[/TD]
[TD="align: right"]0.62[/TD]
[/TR]
[TR]
[TD]Deutsche Bank AG[/TD]
[TD="align: right"]-0.42[/TD]
[TD="align: right"]0.52[/TD]
[/TR]
[TR]
[TD]Credit Suisse AG[/TD]
[TD="align: right"]3.54[/TD]
[TD="align: right"]0.89[/TD]
[/TR]
</tbody>[/TABLE]


Thank you

 

[Jon Peltier]

Set up your data as follows. X values in one column, Y values in the adjacent column to the right. Put a blank cell above the X values, and a label above the Y values. The blank cell helps Excel parse your data into X and Y. Then select your data and make an XY Scatter chart.

 

[00alex00]

Set up your data as follows. X values in one column, Y values in the adjacent column to the right. Put a blank cell above the X values, and a label above the Y values. The blank cell helps Excel parse your data into X and Y. Then select your data and make an XY Scatter chart.

Great, thank you it worked!!!