One data series - Two Vertical axes

[develaavi]

Is there a way to make a chart which has two vertical axes with only one data series.
I browsed on the net for this, but was answered that another data series should be taken and is plotted on secondary axis.
So is there a way to take into account a single data series and plot on both the axes, one of them being in Log Scale.

Please see the image.
Have anyone tried like this
chart-secondary axis.jpg

[Kaper]

But ... the right one is not really the axis. Do you know this?
These are labels for each one of the lines on the nomogram chart.

How to:
Prepare such chart as scatter plot (XY chart) with lines only (no points).
Then add extra series where x is 6 and Y is the value for each nomogramed line at x=6 and display this as an additional series on the plot with labels (formatting default is what you need - label showing Y value and located on the right from the point.
That's it.

[develaavi]

But ... the right one is not really the axis. Do you know this?
These are labels for each one of the lines on the nomogram chart.

How to:
Prepare such chart as scatter plot (XY chart) with lines only (no points).
Then add extra series where x is 6 and Y is the value for each nomogramed line at x=6 and display this as an additional series on the plot with labels (formatting default is what you need - label showing Y value and located on the right from the point.
That's it.

I got your point. I have extracted the points thorugh an online tool. Now i plotted the data as shown in attachment. Next is a confusion....

[Andy Pope]

add a new series with a point for each line. Note one of your series has no x=6 data point so you will need to determine what the Y position for that series is.

Use this free addin to link data labels for that series to a range.
http://www.appspro.com/Utilities/ChartLabeler.htm

[Kaper]

just 3 minor improvements:
* in Z1:AG1 write your values to be displayed (0.1, 0.5, 1.0 ...)
* format the cell AB1 to show 1 decimal place otherwise on a plot you will get 1 (not 1.0) (may be you do not mind - is so skip it)
* correct named range _C7 (do it with Ctrl+F3) to point to:
='C1'!$S$1:$T$94
not
='C1'!$S$1:$T$93

Enjoy!

[develaavi]

just 3 minor improvements:
* in Z1:AG1 write your values to be displayed (0.1, 0.5, 1.0 ...)
* format the cell AB1 to show 1 decimal place otherwise on a plot you will get 1 (not 1.0) (may be you do not mind - is so skip it)
* correct named range _C7 (do it with Ctrl+F3) to point to:
='C1'!$S$1:$T$94
not
='C1'!$S$1:$T$93

Enjoy!

But the real problem, is how to interpolate the curve which is assumed to be at the label 30 (30 is an interpolated value between the label, The label values are 0.1,0.5,1,2,5,10,20,100). Since the fit for all curves is not the same , how can we interpolate the curves if a need a value (on x-axis) which intersects the curves of 30 label.

Iam trying to find a fit for all curves of equal degree. But your help is needed.

[develaavi]

add a new series with a point for each line. Note one of your series has no x=6 data point so you will need to determine what the Y position for that series is.

Use this free addin to link data labels for that series to a range.
http://www.appspro.com/Utilities/ChartLabeler.htm

Go that. But sir, now how to interpolate the curves. In the next msg i'll show you the fits for those curves.

[Kaper]

But the real problem, is how to interpolate the curve which is assumed to be at the label 30 (30 is an interpolated value between the label, The label values are 0.1,0.5,1,2,5,10,20,100). Since the fit for all curves is not the same , how can we interpolate the curves if a need a value (on x-axis) which intersects the curves of 30 label.

But for this you started another thread: http://www.excelforum.com/excel-char...ml#post3569813 and crossposted on http://www.ozgrid.com/forum/showthread.php?t=185861 - where you received an answer 2 days ago - have you checked it?

[develaavi]

But for this you started another thread: http://www.excelforum.com/excel-char...ml#post3569813 and crossposted on http://www.ozgrid.com/forum/showthread.php?t=185861 - where you received an answer 2 days ago - have you checked it?

Thanks for the info...Iam in need of it...