Morning Forum -

I have several documents that I apply transparency in graphs for future dates - These usually represent some sort of projection number.

I am wondering if there is some vba I could run to go through and set transparency levels to 100% if the day has passed as most of the reporting is done the day after -

Was thinking of a loop that runs through each series and goes until points is greater than or equal to day

So if for example it ran today, it would go through Series collection (1).Points(1) - Points(10) and then go to next series until all are set to .Transparency = 0

Then it would go to next chart object.

Had a few runs and I am jacking up my graphs..lol so coming here hoping someone will have this tackled already and willing to share the code...

Loop through All sheets and All Charts setting all Points that are in the past (These are MTD Graphs) in each series to solid from their current 75% transparency setting. Hope my lack of sleep is not coming through in this post

Cheers