Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Bob
Bob asked in Computers & InternetSoftware · 5 years ago

How do you set up a dynamic range for dates in MS Excel graphing?

Update:

I have dates (Monday of each week) across row 1 and data on various rows beneath.

My ranges are:

DataRange = Offset($c$1,0,0,match(today(),$c$1:$cc1,1))

ProdLine1Series = Offset($c$4,0,0,match(today(),$c$1:$cc$1,1))

In the chart series name, I put

= ProdLine1Series

and get "The formula you entered contains an error." To try to isolate the problem, I have used made just the series and just the X axis dynamic, but still get the same error. Any idea what I'm doing wrong?

1 Answer

Relevance
  • BT_Bot
    Lv 5
    5 years ago
    Favorite Answer

    Try adding the sheet or workbook name to your named range depending if the named range's scope.

    For example if your named range's scope is workbook and the same workbook is named myXLBook.xlsx then enter data in chart as:

    = myXLBook.xlsx!ProdLine1Series

Still have questions? Get your answers by asking now.