I have only ever worked with graphs where the data is static. i.e. I have 13 columns [Jan 13 -Jan 14] and 20 Rows of data..
I have now been ased to create a graph where I will have 13 columns but the number of rows of data will change.
I therefore need to be able to ensure that I always pick up the 'Grand Total' row which will be 'Legen Entries (Series)' The Horizontal (Category) Axis [Columns] will be static
Is this possible?
Thanks in advance