Hi folks,

I am a bit stumped on this one. I am attempting to generate a target line using a pivot table generated bar graph (yes it needs to be a bar graph).

I have tried using a bar and line chart however I cannot figure out how to add the target line figure (a set number, in this case 10), which is a constant.

I am curious to know if there is a VBA script i can insert into the pivot table/chart to create a target line please? Or failing that, if the bar/line chart can have the line as the target line (ie fixed to the nominated value).

Thanks in advance.

:D