What is the best way to insert goal lines in a pivot chart

I have allot of pivot charts and they will be refreshed and I am wondering
how do you enter a goal line and have it be and print in the right spot

Might I be able to change the color of the grid line at a particualr value
or do I have to draw in a line.

perhaps someone could comment on vba code to enter a colored goal line at a
particular value say for the active chart only

Really appreciate any suggestions - I have allot fo charts to make.

feel free to post or email me at

I often add a calculated field which is my "target goal" and add that as a
series to the graph.

Hope that helps

Steve

"Todd F." wrote:

What is the best way to insert goal lines in a pivot chart

I have allot of pivot charts and they will be refreshed and I am wondering
how do you enter a goal line and have it be and print in the right spot

Might I be able to change the color of the grid line at a particualr value
or do I have to draw in a line.

perhaps someone could comment on vba code to enter a colored goal line at a
particular value say for the active chart only

Really appreciate any suggestions - I have allot fo charts to make.

feel free to post or email me at