Constant Line across Bar Graph

[dan_pafc]

Hi, I have a bar graph which I need to add a constant line to in order to show target. I know it can be done using a drawing object but would prefer not to.

Any other idea's?

Dan.

 

[RoryA]

You can add a second series of data next to your bar data, use the same value (the target value) for each item and change the chart type for that series to line chart (select the series, right-click, choose Chart Type, pick the line chart and make sure the 'Apply to selection' option is checked).

 

[dan_pafc]

You can add a second series of data next to your bar data, use the same value (the target value) for each item and change the chart type for that series to line chart (select the series, right-click, choose Chart Type, pick the line chart and make sure the 'Apply to selection' option is checked).

Cheers Rory.