+ Reply to Thread
Results 1 to 8 of 8

Create a Chart row by row

  1. #1
    Registered User
    Join Date
    07-30-2012
    Location
    Norfolk, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    14

    Create a Chart row by row

    Hi I am trying to create a code to create a chart row by row without knowing how many rows will have information. here is a similar thread I saw earlier. http://www.excelforum.com/excel-char...97#post2875997

    Here is the workbook I am trying to work with. I have some code already but I dont think it is effective or will help me reach my end goal.

    Coding practice.xls

    Thanks for the help

  2. #2
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: Create a Chart row by row

    Try this:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-30-2012
    Location
    Norfolk, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Create a Chart row by row

    You are a life saver. Thank you

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Create a Chart row by row

    @ petebmor

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  5. #5
    Registered User
    Join Date
    07-30-2012
    Location
    Norfolk, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Create a Chart row by row

    Do you have any advice to writing the code in order to ignore a row of zeros?

  6. #6
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: Create a Chart row by row

    do this:

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    07-30-2012
    Location
    Norfolk, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Create a Chart row by row

    Awesome thank you. i just checked it out and it worked perfectly. There is one thing I would like to modify though. I'm trying to make this so anyone can use the program and when something is moved while the macro is running and the charts are be moved to a ppt presentation, it stops running. Is there way to stop this from happening? or is it inevitable?

  8. #8
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: Create a Chart row by row

    In this form it is inevitable, becuase i make use of ActiveSheet (that is the dirty way).
    You could consider making it so, to change these references to things like "application.Worksheets("name")." to make it a bit more foulproof, however this takes some time and trial and error to get this done.

    One other thing you could consider is putting "Application.ScreenUpdating = False" on top of your script and end it with "Application.ScreenUpdating = True" to speed some things up.
    Not tested it though, this could conflict with the Activesheet reference as well.

+ 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