| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable Range to be used in a chart
I would like to set up a variable range that I can use in a chart.
I am tracking five columns of data that I add to every day. I would like to track the most recent three weeks in a chart. I am thinking that this should be do-able using some variation of the offset function and the Max function but I am not really sure how to set it up any ideas would be appreciated =OFFSET(Sheet1!$A$3,0,0,COUNTA(Sheet1!$A$2:$A$550) ,1) -- Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Step Chart using range names | Charts and Charting in Excel | |||
| Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
| How to create a chart based on a 2 dim data range dynamical in 1 d | Charts and Charting in Excel | |||
| Altering the range that is plotted by a chart via VBA | Charts and Charting in Excel | |||
| How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
Threaded Mode
