Want to use same Chart against changing data and variable titles?
Excel 2003: I have data for a number of branch offices that is set up in the
same format on a spreadsheet. I want to use the same chart to successively display each branch's data and change the title to identify the branch. |
I have daily data of some of my scrips in rows in a sheet.
when I click a particular scrip name that scrip's chart comes up. I presume that this is the similar thing you want. if so send an email I shall send you my sheet as attachment by email and you can modify to suit you -- remove dollars from the following address "J Manning" <J wrote in message ... Excel 2003: I have data for a number of branch offices that is set up in the same format on a spreadsheet. I want to use the same chart to successively display each branch's data and change the title to identify the branch. |
See
Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/index.html If your data are on the same worksheet, example 4 should apply. If your data are on different worksheets, use the INDIRECT function to change the sheet name. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , =?Utf- 8?B?SiBNYW5uaW5n?= <J says... Excel 2003: I have data for a number of branch offices that is set up in the same format on a spreadsheet. I want to use the same chart to successively display each branch's data and change the title to identify the branch. |
All times are GMT +1. The time now is 10:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com