Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset Graph reference problem
My X axis values start at A8 (headings on the 7th row). I have four series
one in each of columns C through F. (Column B has some misc. data). # of rows grows as data is added. I have succesfully used named formulas in the past when I had one X axis in A and one Y series in B: =OFFSET('sheet'!$A$5,COUNTA('sheet'!$B:$B)-'sheet'!12,0,'sheet'!12,1) I name this X =OFFSET('sheet'!X,0,1) I name this Y So my problems a How do I modify this formula for when my series is not the next column from my X axis data. AND Y is mostly defined by X. So I need four X fromulas (X1, X2, etc) to define my four series. But I don't think I can have multiple X ranges in the graph. How do I modify to get around this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset Graph reference problem
If your series is one column to the right of your x axis, use this:
=OFFSET('sheet'!X,0,1) I name this Y 2 col =OFFSET('sheet'!X,0,2) 3 col =OFFSET('sheet'!X,0,3) You can have multiple X axes in the graph, but you'll need to change them. I usually do it with CHART - Source Data and change the series as needed. "Aaron" wrote: My X axis values start at A8 (headings on the 7th row). I have four series one in each of columns C through F. (Column B has some misc. data). # of rows grows as data is added. I have succesfully used named formulas in the past when I had one X axis in A and one Y series in B: =OFFSET('sheet'!$A$5,COUNTA('sheet'!$B:$B)-'sheet'!12,0,'sheet'!12,1) I name this X =OFFSET('sheet'!X,0,1) I name this Y So my problems a How do I modify this formula for when my series is not the next column from my X axis data. AND Y is mostly defined by X. So I need four X fromulas (X1, X2, etc) to define my four series. But I don't think I can have multiple X ranges in the graph. How do I modify to get around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic reference in OFFSET function | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
How to reference an offset from a cell? | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |