View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Secondary Axis - not possible

*Don't* try Format Chart Area.
*Don't* try to select more than one series at a time.

Select *ONE* series.
Either right-click on that series and choose Format Data Series
Or choose Selected Data Series from the Format menu.
In either case, then choose the Axis tab.
--
David Biddulph

"BAZZ" wrote in message
...
David, thanks for the quick reply. However, I have 3 series but when I
choose al 3 and then go to Format tab, Chart Area and then click on Format
Selection all I get is a possibility to Format the Chart Area. I cannot
discover a Format Series/Axis botton. Hmm

Bazz

"David Biddulph" wrote:

Firstly you need more than one series in the chart.
Select the series that you want to put on the secondary axis and Format
Series/ Axis.
--
David Biddulph

"BAZZ" wrote in message
...
I want to create a secondary axis, but when I go to chart area, format
selection I only get Format Chart Area and no option for <series
option -
plot option
And yes it is legal SW.
Do I have to install somthing additional?