Table changing format options with macro

[joshuafournier]

Greetings,

I have a table that is always present. Depending on the people involved it displays the people appropriately on the bottom. Every thing works except it keeps changing my table format. Each measurable needs to have exact colours etc. When it runs the VBA macro it changes all the colours outlines patterns etc. How do i stop that from happening. I just want it to keep what i have already for the table. This is my code for 1 person.

Activesheet.chartobjects ("chart7")
activechart.seriescollection (1).xvalues="=bf12:bf12"
activechart.seriescollection (2).xvalues="=bf12:bf12"
activechart.seriescollection (3).xvalues="=bf12:bf12"
activechart.seriescollection (4).xvalues="=bf12:bf12"
activechart.seriescollection (5).xvalues="=bf12:bf12"

Activechart.seriescollection (1).values="=bn12:bn12"
Activechart.seriescollection (2).values="=bo12:bo12"
Activechart.seriescollection (3).values="=bk12:bk12"
Activechart.seriescollection (4).values="=bl12:bl12"
Activechart.seriescollection (5).values="=bp12:bp12"