Results 1 to 2 of 2
  1. #1
    shera
    Guest

    Excel Template - dynamic chart (Excel xp)

    I want to create an excel template with predefined columns and if you add any more new information, the chart automatically updates. For eg:

    I currently have:
    Joe 7
    Doe 9
    Loe 10

    Well I have the chart ..... for them but if user B uses the template and puts four rows instead of 3, i want it to dynamically create the chart in a separate sheet for all teh four rows and so on....

    I am new to this kind of stuff (excel) so please bear with me but I am a programmer by profession so I will understand any techy jargon yall post.

    Thanks

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template - dynamic chart (Excel xp)

    I have attached a workbook that I downloaded from CompuServe quite a while ago that shows how to automate a chart. I have forgotten who the author was, but I think it might have been Bill Manville.
    Attached Files Attached Files
    Legare Coleman

Posting Permissions

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