Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to graph two separate named ranges as a continuous data series. Example:
Series 1; "PastMonthActuals" = Sheet2("A1:A3") Series 2; "Projections" = Sheet3("A4:A12") I'm not trying to graph these as separate series, I want it to all be one line. In my real workbook these are dynamic ranges, but this simple example will suffice. What is the best way (syntax) to set up a new named range that concatenates the values so that I can feed it into my graph as one series of 12 points? I've tried the obvious, such as: "AllPts" = PastMonthActuals & Projections Thank you, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
concatenate dynamic ranges | Excel Worksheet Functions | |||
named ranges | Charts and Charting in Excel | |||
Concatenate a reference to named ranges in other workbook | Excel Worksheet Functions | |||
Help to adapt Formula syntax to work with Dynamic Named Ranges | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) |