Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charts (Excel 97)

    Is it possible and what is the easiest way, if possible, to create charts from more than one workbook? Or are you better off creating one workbook that has the data linked to it?

    Thank you for your time. Fay

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts (Excel 97)

    Just make your chart with the data coming from different workbooks and then click the series and position the mouse pointer in the editbox, then enter CTRL-ALT-F9 to make your data independent of the workbooks.

Posting Permissions

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