Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Charting By Dates
This is in reference to Jon Peltier's article on dyamic charts.
http://pubs.logicalexpressions.com/P...cle.asp?ID=246 My question is the example given is using data that goes down a column. Column A is the dates, Column B is the data, ect... My data flows across rows, so all my dates are in row 1 and the data is in row2. I would like some help converting Mr. Peltiers technique to fit my need. This code needs to go across a row instead of down a column. =OFFSET(AllDates,MATCH(StartDate,AllDates,1)-1,0,MATCH(EndDate,AllDates,1)-MATCH(StartDate,AllDates,1)+1,1) As well as this one I presume. =OFFSET(ChartDates,0,1) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic charting | Charts and Charting in Excel | |||
dynamic charting | Charts and Charting in Excel | |||
Dynamic charting | Charts and Charting in Excel | |||
Dynamic Charting | Excel Discussion (Misc queries) | |||
Dynamic charting | Excel Discussion (Misc queries) |