Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    Muscat, Oman
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charts in separate window (97,2000, XP)

    I have never understood why there is a separate chart tag on the Toolsoptions menu. If there are no charts in the workbook most of the parameters are greyed out apart from tips and value. If you do have an active chart the Chart menu appears, of course, but you still have to go to the separate Toolsoptionschart menu to get useful stuff associated with plotting values and sizing charts with the window. Why can

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts in separate window (97,2000, XP)

    Rightclick the chart, choose Chart types, click the Custom types Tab, select "User defined", click "Add", enter a name, press OK, click "Set as default chart". Now next time you create a chart, it should be this one.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Star Lounger
    Join Date
    Apr 2001
    Location
    Muscat, Oman
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts in separate window (97,2000, XP)

    Many thanks. Great tip! It will certainly save me a lot of work.
    Brian

Posting Permissions

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