View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
DaleB DaleB is offline
external usenet poster
 
Posts: 17
Default Adding a secondary Axis to a graph

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