![]() |
Excel 2007 chart series - unable to use structured references
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,CompanyWideSour ceData!$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? |
All times are GMT +1. The time now is 07:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com