xcel Color Graph Points Of Multiple Series Collections

[Grandeco]

Hi,

I'm creating a small excel sheet for our Maintenance department.

They enter the score of their normal maintenance and preventive maintenance each month for each production line.

Line 1 1/03/2013 PREVENTIVE 100
Line 1 1/03/2013 NORMAL 98

They do this in a sheet just for this.
From this sheet I create a pivot table which displays the needed values based on their selection in several slicers.
Based on the value (100, 98, 88) I then color these cell values.

Form this pivot table I create a graph which displays the exact same data. But I would like the graph to display the same colors. So I go over each series collection, and check the values. I then modify those points formatting based on the value they have.
This works perfectly if I have one series collection. When I have multiple changing the color of a point also changes the color of a point in another series collection.

Please Login or Register  to view this content.

Even when I manually change the color of 1 point (or by the code below), it changes the color of a point in another series collection.
Does this make sense to anyone? Do they refer to the same point somehow??

Please Login or Register  to view this content.

I have attached the file in question.
This is being programmed on a Server 2008 R2 with Office 2010.
The same problem happens on my Windows 7 with 2013.

I have posted this question on "Dream.In.Code" but after more than 100 views I haven't gotten a response.
Thread

I have also placed this question on the Microsoft Community forums since this project is getting urgent.
Thread


Hopefully anyone knows how or why this is happening.
Thank you,
Domien

[Grandeco]

Anyone have a clue?

[Grandeco]

Hi,

Instead of using .Points(p).Format.Fill.Forecolor = ...
I had to use .Points(p).Interior.Color = ...

Not quite sure what's the difference though

the site that led me to the sollution

Domien

My final code:

Please Login or Register  to view this content.