| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Do I really need OFFSET?
I have defined a Dynamic Name as follows:
=OFFSET(Sheet1!$A$4,COUNTA(Sheet1!$A:$A)-1,0,-MIN(chtLen,COUNTA(Sheet1!$A:$A)-1),1) The label for the data is in A3, the data starts in A5 and continues downward. The definition above does start plotting from A5 but adds a blank cell. There is always one extra empty data point that is plotted. Is there an easy fix so that the plot starts at A5 and stops at the last data point? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Offset | Excel Discussion (Misc queries) | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| OFFSET HELP | Excel Worksheet Functions | |||
| Offset. | Excel Worksheet Functions | |||
| offset | Excel Worksheet Functions | |||
Threaded Mode
