Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Dec 2005
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Both Y-axis on right side of chart (2000)

    I have a chart which has the primay and secondary axis on the right side of the chart and I can't figure out how to move the primary axis back to the left side of the chart. I ended up here by accidentally deleting the source data and not entering it back correctly.

    Is this a setting that I can't find?

    Thanks!

    Larry

    P.S. I recreated the chart, but am trying to figure out how to fix the first one in case I do this again.

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Both Y-axis on right side of chart (2000)

    Click on a point for the series that you want on the left side (if you accidently click on the wrong series, you can tab or shift-tab until the correct series is selected). Then use the Format | Selected Data Series menu and the Axis tab. Finally, click on Primary Axis and press OK. However, if you have lost the sorce data, then I don't think that your chart will be correct: it will use the new data for the plot. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

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