Can I use 'names' in defining a series in a graph

Discussion in 'Microsoft Excel Charting' started by dbasmb, Dec 11, 2009.

  1. dbasmb

    dbasmb Guest

    I have successfully used the name feature to name individual cells and ranges
    of cells and than have used them in formulas. However, when I try to use a
    name in the definition of a series on a graph, it says there is an invalid
    reference. Am I doing something wrong, or can you not use names in series
    definitions?

    Thanks for your help.
     
    dbasmb, Dec 11, 2009
    #1
    1. Advertisements

  2. dbasmb

    Jon Peltier Guest

    There are innumerable examples on the internet showing how to use names
    as your chart source data. See for example:

    http://peltiertech.com/WordPress/dynamic-charts/
    http://peltiertech.com/Excel/Charts/Dynamics.html

    What is probably leading to your error is using just the name, without
    referencing its parent worksheet or workbook. For example, the name
    ChartData will produce an error by itself, but if you prefix it by the
    sheet name, 'Data Sheet'!ChartData.

    - Jon
    -------
    Jon Peltier
    Peltier Technical Services, Inc.
    http://peltiertech.com/



    dbasmb wrote:
    > I have successfully used the name feature to name individual cells and ranges
    > of cells and than have used them in formulas. However, when I try to use a
    > name in the definition of a series on a graph, it says there is an invalid
    > reference. Am I doing something wrong, or can you not use names in series
    > definitions?
    >
    > Thanks for your help.
     
    Jon Peltier, Dec 11, 2009
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jcknortheast
    Replies:
    1
    Views:
    2,686
    Stephen Bullen
    Dec 5, 2003
  2. rich zielinski via OfficeKB.com

    series graph -- one series being added to another series

    rich zielinski via OfficeKB.com, Mar 28, 2005, in forum: Microsoft Excel Charting
    Replies:
    3
    Views:
    514
    rich zielinski via OfficeKB.com
    Mar 30, 2005
  3. Guest
    Replies:
    1
    Views:
    2,125
    Tushar Mehta
    Jan 3, 2006
  4. Leo Bueno
    Replies:
    1
    Views:
    527
    Andy Pope
    Aug 2, 2007
  5. mrsatroy

    Defining areas on a graph

    mrsatroy, Apr 19, 2010, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    375
    Bernard Liengme
    Apr 19, 2010
Loading...

Share This Page