I
Ilia
In Excel 2007 spreadsheet of .xlsm type, I have a table called
CompanyWideSource. It's located in A2:F14 (including headers) on a sheet
called CompanyWideSourceData. Column A contains Date and column F contains
Total Hours, with some intermediate calculations in between.
When I setup a chart for it using Insert Chart, I get the following series
function:
=SERIES(CompanyWideSourceData!$F$2,CompanyWideSourceData!$A$3:$A$14,CompanyWideSourceData!$F$3:$F$14,1)
What I really want is to refer to the columns as structured references, for
when the table is updated:
=SERIES(CompanyWideOT[[#Headers],[Date]],CompanyWideOT[[#Data],[Date]],CompanyWideOT[[#Data],[Total Hours]],1)
However, whenever I replace the series formula with the above, it converts
to A1-style references. Is this desired behavior?
CompanyWideSource. It's located in A2:F14 (including headers) on a sheet
called CompanyWideSourceData. Column A contains Date and column F contains
Total Hours, with some intermediate calculations in between.
When I setup a chart for it using Insert Chart, I get the following series
function:
=SERIES(CompanyWideSourceData!$F$2,CompanyWideSourceData!$A$3:$A$14,CompanyWideSourceData!$F$3:$F$14,1)
What I really want is to refer to the columns as structured references, for
when the table is updated:
=SERIES(CompanyWideOT[[#Headers],[Date]],CompanyWideOT[[#Data],[Date]],CompanyWideOT[[#Data],[Total Hours]],1)
However, whenever I replace the series formula with the above, it converts
to A1-style references. Is this desired behavior?