ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel 2007 chart series - unable to use structured references (https://www.excelbanter.com/charts-charting-excel/167382-excel-2007-chart-series-unable-use-structured-references.html)

Ilia

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