In a sheet called CashP in starting in cell A1 in col A I have dates.
In col B I have numbers. I have created a line graph, dates on X axis and numbers on Y.
The number of dates available varies and I want the graph to be dynamic with the number of dates.
Accordingly I have created a range called "Dates" and the range is defined by the formula =OFFSET(CashP!$A$1,0,0,COUNT(CashP!$A:$A),1).
When I go to the range "Dates" I can see the range works dynamically.
The problem I have I cannot get the the range "Dates" into the graph. I have tries "selecte Data", then double clicked on X axis and clicked edit, but excel will not allow me to enter =dates as a range name.
Your thoughts please?
Mark
In col B I have numbers. I have created a line graph, dates on X axis and numbers on Y.
The number of dates available varies and I want the graph to be dynamic with the number of dates.
Accordingly I have created a range called "Dates" and the range is defined by the formula =OFFSET(CashP!$A$1,0,0,COUNT(CashP!$A:$A),1).
When I go to the range "Dates" I can see the range works dynamically.
The problem I have I cannot get the the range "Dates" into the graph. I have tries "selecte Data", then double clicked on X axis and clicked edit, but excel will not allow me to enter =dates as a range name.
Your thoughts please?
Mark