plotting a single 2D-linegraph with with two Y-axis and one X-axis

[djkahc]

Hi everyone,

Can anyone help me plot a single 2D-line-graph(there should not be two line-graphs) with the one Xaxis and two Yaxis(Y1 nY2). below is the one with shows my data.

X Y1 Y2
10 28936.39 113.03
20 28923.83 112.98
30 28932.22 113.02
40 28935.41 113.03
50 28925.97 112.99
60 28936.98 113.04
70 28919.61 112.97
80 28910.66 112.93
90 28936.85 113.03
100 28932.72 113.02
110 28915.89 112.95
120 28937.64 113.04

ThanQ

Djkahc

[rwgrietveld]

This is what the HELP provides:

Add a secondary axis

When the values in a 2-D chart vary widely from data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) to data series in a 2-D chart, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated data series.

• On a chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.) or in an embedded chart (embedded chart: A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.), click the data series that you want to plot along a secondary value axis.
• On the Format menu, click Selected Data Series.
• On the Axis tab, click Secondary axis.