2 axes allocate series

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

How can I allocate which data series I have against which y axis? I have four
series: 3 numbers (axis 1) and want to allocate my fourth series (%age) to
axis 2.

Thanks
 
Click the 4th data series in the chart and open the Format Data Series
dialog and specify Secondary Axis
best wishes
 
On the Format Series menu, go to the Axis tab (Excel 2003 and earlier) or
whatever the first tab is in 2007, and click primary or secondary as needed.

- Jon
 
Sorted, because it was a %age, it was hard to select format data series to
assign the axis.
 
Hi,

Select the series and then right click Format Data Series.
On the Axis tab choose Plot on Secondary axis.

Cheers
Andy
 
Select any series (or any chart element), then use the up and down arrow
keys to cycle among all of the elements.

- Jon
 
Hi,

Another way to select a hard to select item on a chart is to open the Chart
Object combo box on the Chart toolbar and pick a series. If the item isn't
listed you can still select it if you know its exact name, by typing it into
the combo box and press enter.

You can select 8 major chart elements using the Up and Down cursor keys.
You can select 24+ chart different elements using the Left and Right cursor
keys.

In Excel 2007 the combo box is called Chart Elements and is found in the
first group of the Layout or Format tabs under Chart Tools. On the first tab
of the Format Series dialog box, the Series Options tab is where you specify
which axis the series should display on.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 
Back
Top