Results 1 to 1 of 1

Thread: Plot blank data then plot actual causes runtime error?

Threaded View

  1. Aug 19th, 2005, 01:26 PM #1
    mchow2469
    mchow2469 is offline

    Thread Starter
    Member
    Join Date
    Jul 2005
    Posts
    42

    Plot blank data then plot actual causes runtime error?

    Hi I was wondering why you would get a runtime error with the values property when you plot blank data first, then plot some actual data after that with the same chart?

    For instance:

    ActiveChart.SeriesCollection(1).Values = 'actual data'
    ActiveChart.SeriesCollection(1).Values = 'blank data'
    'cause runtime error when running code below
    ActiveChart.SeriesCollection(1).Values = 'actual data'

    would cause a runtime error? I am getting this bug right now.

    I have included a sample test which graphs actual data, then blank, and then errors when u plot the same actual data again.

    Just activate/deactivate sheet1 to plot different data. thanks!
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width