Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Guys,
I have a spreadsheet with timestamps on col A, then Col B contains the values correspond to timestamps in ColA (Col C thru Col M are similar to Col B as well). I am trying to build a chart in function of time (meaning Values for the X axis would be B2..M2, and Y axis would be B3..M3 for the 1 series, then B3..M3 for the values in x-axis, and B4..M4 for Y axis, so on...). Number of rows is subject to change (time stamps), and I am only interested for the last 21 entries (if there is less than 21 entries, plot them all, otherwise, only plot the last 21 entries). Can someone please help me with the equation (offset?) in name definition? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
Add up a Dynamic Range with 2 Variables | Excel Worksheet Functions | |||
Add up a Dynamic Range with 2 Variables | Excel Worksheet Functions | |||
Dynamic Range Problem | Excel Discussion (Misc queries) | |||
Add a Dynamic Range with 2 Conditions Q | Excel Worksheet Functions |