+ Reply to Thread
Results 1 to 9 of 9

Dynamic Pie chart

  1. #1
    Spammer
    Join Date
    02-12-2007
    Posts
    22

    Dynamic Pie chart

    can anyone help me with attachment, i need a lot of TLC,
    first i would like to do a pi chart that shows me the % of nos to yeses in column H also this must work automatically if i add another row of data and include it in the formula, also if i do a filter on D for example and only show"L2" then the pi chart must only work on visible yeses and nos(got me?).
    and finally i would like to open sheets named after the list in "D" eg L1,L2, etc
    and as i input more rows then the data would also go to the right sheet as well as on main sheet automatically. and the number of rows in main sheet could be as much as 50,000. hope you can help me , ps i dont know anything about vb , pps if possable can show me how the formulas work
    Attached Files Attached Files

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Please add a file with a .XLS extention

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Spammer
    Join Date
    02-12-2007
    Posts
    22

    Question oops

    sorry cant put file with xls extention as this is not my computer and it does not have excel on it , the file was made on excel 2007 and saved to run on 2003 any ideas?

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Try

    File Save as

    then change Save as type to say Excel 97 then everyone should be able to open it

    VBA Noob

  5. #5
    Spammer
    Join Date
    02-12-2007
    Posts
    22

    Smile

    ok will do but will have to put it on tomorrow night as i have to do it on my laptop ( other side of town) so see you tomorrow ok cheers

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

  7. #7
    Spammer
    Join Date
    02-12-2007
    Posts
    22

    xls file

    hi this is the file in xls format hope you can help me
    Attached Files Attached Files

  8. #8
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    This might be a start

    VBA Noob
    Attached Files Attached Files

  9. #9
    Spammer
    Join Date
    02-12-2007
    Posts
    22

    Smile thanks

    cheers mate it works great . now just got to get it to copy rows on different sheets according to the input of one cell in that row , any ideas?

+ 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