can I have two Y-axis in XY (scatter) in excel?

[lamyuwang]

I would like to plot the XY(scatter) with two axis, but i cannot found it, and what i just found is the "line with two axis", but it is not suitable for me as I want there is real scale in X-axis.

if anyone of you know that, I hope you can tell me.

actually what i want to do is the cumulative curve with showing the value and percentage to the last(max) value, so two Y-axis is needed.

thanks ~~ :>

 

[SkipVought]

Hi.

Select the series in the chart that you want on the secondary axis.

Format/Selected Data Series - Axis Tab: Select Secondary Axis Option Button.

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]

 

[tsurikov]

Hi lamyuwang,

If the two plots share the same X axis, you can use the technique SkipVought suggested. If the X axis is not the same, you unfortunately cannot do what you want in Excel and would need to turn to something like Origin or Tecplot.

Good luck!
--Michael

 

[lamyuwang]

Thanks your help~~