Results 1 to 9 of 9

Combine 2 named-ranges for a single series line chart

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Combine 2 named-ranges for a single series line chart

    Hi,

    In the attached WB -

    Sheet A has a 3 cells (A1:A3) named range: AA
    Sheet B has a 7 cells (A11:A17) named range: BB

    In sheet C I would like to plot a 'Line' chart from a Single Series - the combination of AA+BB

    What I have in mind is that the single series source should be:
    2, 3, 1, 7, 5, 9, 8, 4, 6, 10

    In the series source I've tried to type:

    =Book18.xls!AA, Book18.xls!BB
    or:
    ='Book18.xls'!AA, 'Book18.xls'!BB

    Excel excepts only: =Book18.xls!AA OR =Book18.xls!BB but no both

    Any assistance will be appreciated,

    Elm
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1