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..
Bookmarks