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
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.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks