+ Reply to Thread
Results 1 to 1 of 1

Excel 2003 FullSeriesCollection

  1. #1
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    Excel 2003 FullSeriesCollection

    Hey all,

    I previously notified the forums that I had to make a macro for Excel 2003 while I was writing it in 2013.
    Now time has come to transfer my files to 2003 and sadly there are some issues.

    for start: It's significantly slower. Obvious since my laptop is faster. They'll just have to live with it.

    Second: I made a button that makes charts. Looks nice and works fine in 2013.
    Now I tried it in 2003 and it told me that FullSeriesCollection doesn't work. So I tried making the chart without the button and record my actions.
    This is what I want: (hopefully the img loads, its stacks 2 of the 3 groups of values in columns, 1 group of values is represented by a line )
    \1
    (values in this images are 100% fake)

    Is that even possible in 2003?

    Thanks in advance for your time


    -edit-
    In addition,.. the macro I recorded doesn't seem to work.. gives back a 1004 error.
    So not only is the graph not what i want,.. it also doesn't work xD

    -edit2-
    fixed the 1004 error.. but any help is welcome, coz I'm far from recreating my target and keep running in to problems.
    Now I'm able to insert a graph. (it creates a new sheet for some reason before putting it on the right sheet)
    But it messes up all my formulas . Gonna run my head into a wall and then try to fix this.
    \1
    mnDPJ2s.png
    Please help

    -edit3-
    Still messes up my data -.-
    Is there any way to just use my working 2013 file by converting it to an exe or something?
    ==> sorry I just had my head smashed against a wall. ignore this last question

    -edit4-
    Still trying to solve it without getting further...
    The Charts.add triggers a new sheet to be made
    That triggers the macro linked to the main sheet (active - deactive)
    In those activate and deactivate I call for subs.
    • Public boolean Cht_par is added
    • The button that makes the chart now has: Cht_par = true
    • When the deactivate sub is trigged, the Cht_par is changed to False.. somehow :/ <=== I think this causes the data shifts

    -edit5-
    The public was not declared the right place, so it was not seen.
    Fixed that.. the graph gets made, data doesn't shift.

    Now I just need to get the right data to show the right way.
    But ill mark this as solved and ask about that later... since there has not been a reply so far, I doubt that anyone could follow me at all..
    Last edited by Evolta; 05-06-2015 at 08:43 AM.
    Inveniam Viam Aut Faciam

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Saving 2003 macros using excel 2013 now unusable on Excel 2003
    By Bukovnik in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2014, 07:09 PM
  2. Excel 2003 to Excel 2010 and back to Excel 2003 problem
    By keops9876 in forum Excel General
    Replies: 1
    Last Post: 02-02-2013, 07:30 PM
  3. Excel 2003 workbook saved as Excel 97 - 2003 issue
    By Jeff M in forum Excel General
    Replies: 0
    Last Post: 03-22-2006, 04:30 PM
  4. Word 2003 Find/Change Automation from Excel 2003 crashes Excel 200
    By Joel Berry in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-06-2006, 06:25 PM
  5. [SOLVED] Upgrade from Excel 2000 to Excel 2003 without MS Office 2003?
    By brigida3 in forum Excel General
    Replies: 1
    Last Post: 01-22-2006, 01:20 PM

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