Use Value from a Row for PivotChart

Originally Posted by NeedForExcel

Try a Pivot Chart not a regular one.. And try to make a column that holds the Year Values..

So basically your headers will be State, Suburb & Year

Is there any way to do it than making a column that holds the year value. Because my actual data is quite big. Like 1500 x 45 (1500 rows and 55 columns). So if I have to make a column for year values, its gonna be 1500 times 50 = 75,000, for the number of rows. That is quite a inconvenience.