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.
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
venkat1926$$$$@$$$$$$yahoo.com
"J Manning" <J [email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>, =?Utf-
8?B?SiBNYW5uaW5n?= <J [email protected]> 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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks