I need to add a target value line into some graphs but do not know how. Ive got a series of values that are placed in a standard column graph (5 values in the spreadsheet) and want to add a line into the graph based on a single value from the spreadsheet (acting as a target value). If this makes any sense then help would be much appreciated!
Cheers
Phil