Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Secondary Axis required (2003)

    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Secondary Axis required (2003)

    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.

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Secondary Axis required (2003)

    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

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Secondary Axis required (2003)

    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.

  5. #5
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Secondary Axis required (2003)

    Thanks,

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

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Secondary Axis required (2003)

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

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Secondary Axis required (2003)

    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

  8. #8
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Secondary Axis required (2003)

    Great. Works a treat.

  9. #9
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Secondary Axis required (2003)

    <hr>Click on an undesired label.
    Press Delete<hr>
    Is there any way to undo this, short of deleting the legend and recreating it?

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Secondary Axis required (2003)

    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.

  11. #11
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Secondary Axis required (2003)

    <hr>if you've done other things in between, deleting and recreating the legend....<hr>
    I'm usually more in that boat...

    Thanks, Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •