So I have an excel with multiple tabs/sheets each representing a month, so i.e. August 2011, September 2011 etc.
On each sheet I have some data figures, and one important figure which is in Table column "D5" on every sheet.
What I am trying to do is create a new tab/sheet called summary, on and on this sheet have a column chart which represents this "D5" figure for each month.
How can I write the data range in excel for chart to get this figure on all sheets ?
Bookmarks