VBA create chart with specific colors

Hi lucascaletta,

I think this can be something usefull?

Please Login or Register  to view this content.

Just paste the code before your 'End Sub'

Hi "thelongpants" ,

I've get one runtime error, if I would paste ur code before my "end sub":

Runtime Error '1004' (invalid parameters) with the line: a = ch.Chart.SeriesCollection(2).Values

Any ideas?

Hi,

Hm... can you send me your file? Probably something with references or identification of the variables...

Sure, pls take a look to the attached file. I've insert 2 buttons

Hi Lucascaletta,

Please Login or Register  to view this content.

into:

Please Login or Register  to view this content.

It seems that your graph only has 1 collection of data (in my testcase I just created a default graph).

Problem solved?

Kind regards,

Tom

hi,

unfortunately not, you can test it with my attached file in the upper comment.

I've change all SeriesCollection(2) to SeriesCollection(1), no it works. Can u explain this further, pls?

Good job! :-)
Sorry, I was not really focussed.

Explanation:
The way a graph is illustrated / build by Excel is depending on the graph type. Some graphs use multiple collections (series) of points to visualize a line in the graph. Others only use 1 collection, like yours.

More (technical) info can be found on the web, like here: http://www.java2s.com/Code/VBA-Excel...tingCharts.htm

Thanks "thelongpants" for ur support

Hopefully, we'll read us in another thread :P

Hi Lucascaletta,

No problem, my pleasure :-)

We'll see,... I started my experience in VBA with a lot of questions as well, now started returning answers :-)
Please mark this thread as 'solved' and add some reputation to my comments if you like!