Secondary Axis required (2003)

Topic

New Reply

I have a list of names, salaries and bonus rates (as percentages). If I create a column chart based on this data and then add a secondary axis, Excel ‘clusters’ the data. that is each name has one column, split to two colours. How can I separate these? That is, I want the name once and two columns – one for salary and one for bonus rate. Thanks, Andy.

Reply | Quote

Replies

The idea is to add a blank dummy series after the series on the primary axis, and blank dummy series before the series on the secondary axis. This shifts the series.
See the attached workbook, and look at Chart | Source Data, Series tab to see how the dummy series are defined.

Reply | Quote

Hans

I’ve never done much work with charts before but am starting to delve into them. After downloading your attached file, I tried to duplicate it as an exercise. All went well except I was unable to CREATE a secondary axis. Is this not available in xl 2000?
See Attached

Reply | Quote

Do it like this:

– Click on your new chart.

– Select the Bonus series from the dropdown on the Chart toolbar.
– Select Format | Selected Series…
– Activate the Axis tab.
– Click Secondary axis.
– Click OK.

– Select the Series4 series from the dropdown on the Chart toolbar.
– Select Format | Selected Series…
– Activate the Axis tab.
– Click Secondary axis.
– Activate the Series Order tab.
– Click Move Up to make Series4 the first series plotted on the secondary axis.
– Click OK.

Reply | Quote

Thanks,

Just one item left: How do you include or rather, exclude a *series* label from the Legend?

Reply | Quote

Click on the legend.
Click on an undesired label.
Press Delete.

Reply | Quote

Great. Works a treat.

Reply | Quote

[indent]

---

Click on an undesired label.
Press Delete

---

[/indent]
Is there any way to undo this, short of deleting the legend and recreating it?

Reply | Quote

Immediately after deleting it, you can select Edit | Undo, click the Undo button on the toolbar or press Ctrl+Z.
if you’ve done other things in between, deleting and recreating the legend is the only way to get a deleted legend entry back.

Reply | Quote

[indent]

---

if you’ve done other things in between, deleting and recreating the legend….

---

[/indent]
I’m usually more in that boat…

Thanks, Hans.

Reply | Quote

One thing to empahsize with Hans’ instructions

The entire entry, marker and name, must be selected before the delete is pressed.

If only the Marker is selected when delete is pressed, the series will be removed from the chart

Steve

Reply | Quote