+ Reply to Thread
Results 1 to 1 of 1

Can I create a dynamic chart with a dynamic number of series?

  1. #1
    Registered User
    Join Date
    07-27-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Can I create a dynamic chart with a dynamic number of series?

    Is it possible to create a dynamic chart which will accommodate the addition of an unknown number of additional dynamic series using Excel 2007?
    That is, I have a db query feeding a table and there will be new rows added each day AND new columns:

    ............Employee 1.....Employee 2.....Employee 3.....Employee 4.....Employee 5
    Jan 1.....10....................5
    Jan 2.....9......................1
    Jan 3.....12....................11..................8.....................55
    Jan 4.....14....................12..................10...................1...................1
    Jan 5.....19....................13..................13...................11.................10
    Jan 6.....12....................15..................16...................16.................18


    As you can see, there is more than one series and new series come on line all the time as new employees are added.

    I can easily define the dynamic range:
    rowscell=counta(a2:a9999)
    columnscell=counta(b1:b9999)
    myrange=offset(mysheet!$a$1,0,0,rowscell,columnscell)

    However, when I try to use myrange as the graph data range I get a "The formula you typed contains an error" dialog.

    Any suggestions?
    Last edited by SG2; 06-24-2011 at 08:58 AM. Reason: updated title

+ 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