+ Reply to Thread
Results 1 to 3 of 3

Want to use same Chart against changing data and variable titles?

  1. #1
    J Manning
    Guest

    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.

  2. #2
    R.VENKATARAMAN
    Guest

    Re: Want to use same Chart against changing data and variable titles?

    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 Manning@discussions.microsoft.com> wrote in message
    news:C947CACB-B9EB-4F42-A2F5-64B71F85643B@microsoft.com...
    > 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.




  3. #3
    Tushar Mehta
    Guest

    Re: Want to use same Chart against changing data and variable titles?

    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 <C947CACB-B9EB-4F42-A2F5-64B71F85643B@microsoft.com>, =?Utf-
    8?B?SiBNYW5uaW5n?= <J Manning@discussions.microsoft.com> 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.
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1