adding colour to sections of a line graph

hi, i have a line graph that i want to colour everytime there is a cetain type of attack in football......this is a very short section so i would need to do this for a large data file.

can someone help ??????

everytime there is a cetain type of attack in football

That's a bit vague, but try running the macro "LineColor" in the attachment

hi, im probably being an idiot here, but how do i open this "linecolor" macro?

Alt+F8 then run macro

sorry guys but i need to be walked through this as i dont have a clue what this macro "LineColor¨ where to find it and how to run it

really appreciate you all baby sitting me on this

Open the excel file, on your keyboard press Alt+8
a macro window open select Sheet1.LineColor and run

See attached picture
Sheet1.LineColor.jpg