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
Bookmarks