+ Reply to Thread
Results 1 to 6 of 6

Error 1004 on SeriesCollection

  1. #1
    Registered User
    Join Date
    08-24-2010
    Location
    POZnan*,Poland
    MS-Off Ver
    Excel 2003
    Posts
    5

    Error 1004 on SeriesCollection

    Hi again,

    I wrote macro:
    Please Login or Register  to view this content.
    But it doesn't work because of run-time error 1004 : 'method "series collection" of object "_chart" failed' (on marked by ->>>> line). Any idea why?

    I have just noticed that problem is in col. B because it`s imported from txt files not enter manually to sheet but still can't find solution.
    Attached Files Attached Files
    Last edited by d_omin; 08-27-2010 at 05:49 AM.
    Best regards,
    d_omin
    'Part of the inhumanity of the computer is that, once it is competently programmed and working smoothly, it is completely honest...' (Isaac Asimov)

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,480

    Re: Error 1004 on SeriesCollection

    It errors for me because you are trying to code against seriescollection(2) when the chart only has 1 series of data.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-24-2010
    Location
    POZnan*,Poland
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Error 1004 on SeriesCollection

    So, why when data in col. B are entered manually it works fine?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,480

    Re: Error 1004 on SeriesCollection

    You need to explain which col B you are talking about.

    You didn't explain how to use your file so I simple pressed the Import button, select the .txt file. The pressed Masa option and Kresl! button.

  5. #5
    Registered User
    Join Date
    08-24-2010
    Location
    POZnan*,Poland
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Error 1004 on SeriesCollection

    It works exactly as you wrote. You're right when I put
    Please Login or Register  to view this content.
    Before line causing error it works fine.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,480

    Re: Error 1004 on SeriesCollection

    You might want to check if the chart has enough series before adding new ones.

    Please Login or Register  to view this content.

+ 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