Hi:
I am having trouble adding a secondary axis to a graph.
I am follwoing Excels' built-in Help and that shown Section 4.6 Using
Multiple Axes of David Bourg's book, "Excel Scientific and Engineering
Cookbook", but the instructions either aren't clear enough or soemthing is
missing.

Here is Microsoft's built-in Help along with my commnets after each step.

1) 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.

I have an x-y graph on the right-hand-side of my Excel spreadsheet.
How do I select a series ? Clicking & Dragging over the column of data
that I want along the secondary axis does not yield me what is involved
in Step 2....I do not get the menu selection needed in Step 2.

2) On the Format menu, click Selected Data Series.

I do not find the selection (Selected Data Series) under the spreadsheet's
Format menu. Thus, I cannot perfrom Step 3.

3) On the Axis tab, click Secondary axis.

Any ideas ?

Thank you...DaleB

You need to click in the chart, clicking the line corresponding to the
series in question (or a point in the series if you have drawn only the
points without the lines between them). You don't select the series by
clicking in the data sheet; it has to be in the chart.
--
David Biddulph

"DaleB" wrote in message
...
Hi:
I am having trouble adding a secondary axis to a graph.
I am follwoing Excels' built-in Help and that shown Section 4.6 Using
Multiple Axes of David Bourg's book, "Excel Scientific and Engineering
Cookbook", but the instructions either aren't clear enough or soemthing is
missing.

Here is Microsoft's built-in Help along with my commnets after each step.

1) 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.

I have an x-y graph on the right-hand-side of my Excel spreadsheet.
How do I select a series ? Clicking & Dragging over the column of data
that I want along the secondary axis does not yield me what is involved
in Step 2....I do not get the menu selection needed in Step 2.

2) On the Format menu, click Selected Data Series.

I do not find the selection (Selected Data Series) under the spreadsheet's
Format menu. Thus, I cannot perfrom Step 3.

3) On the Axis tab, click Secondary axis.

Any ideas ?

Thank you...DaleB

Thank you

"David Biddulph" wrote:

You need to click in the chart, clicking the line corresponding to the
series in question (or a point in the series if you have drawn only the
points without the lines between them). You don't select the series by
clicking in the data sheet; it has to be in the chart.
--
David Biddulph

"DaleB" wrote in message
...
Hi:
I am having trouble adding a secondary axis to a graph.
I am follwoing Excels' built-in Help and that shown Section 4.6 Using
Multiple Axes of David Bourg's book, "Excel Scientific and Engineering
Cookbook", but the instructions either aren't clear enough or soemthing is
missing.

Here is Microsoft's built-in Help along with my commnets after each step.

1) 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.

I have an x-y graph on the right-hand-side of my Excel spreadsheet.
How do I select a series ? Clicking & Dragging over the column of data
that I want along the secondary axis does not yield me what is involved
in Step 2....I do not get the menu selection needed in Step 2.

2) On the Format menu, click Selected Data Series.

I do not find the selection (Selected Data Series) under the spreadsheet's
Format menu. Thus, I cannot perfrom Step 3.

3) On the Axis tab, click Secondary axis.

Any ideas ?

Thank you...DaleB