Results 1 to 2 of 2

Thread: Creating a line chart in Excel VBA

Threaded View

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Apr 2002
    Posts
    27

    Creating a line chart in Excel VBA

    Hi everyone,
    I've asked about this before, and decided a pie chart wasnt the way to go. I need a chart to be dyamically created when the Command Button "Display Graph" is pressed, to show the values in the range of cells K12-N50 in the Pipeline sheet (not the totals, just the values themselve). Also, the legend should display the titles in cells K11-N11 in Pipeline.
    For a while it was ok, then started doing something odd. Now its not displaying anything. Also I'd like something inside the code that if the chart that is created dynamically already exists, replace it with the updated graph (delete+replace?).
    If anyone can help, heres the files! (the spreadsheet takes its values from the database)
    Attached Files Attached Files

Posting Permissions

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



Click Here to Expand Forum to Full Width