Ask Your Question

Add target line to calc chart [closed]

asked 2014-02-12 16:11:20 +0100

oldjingleballicks gravatar image

updated 2014-02-12 16:11:57 +0100

I have created this chart with Calc: chart

In this case "60" is the "target", so I would like to show a horizontal line going across the chart at 60, to visualize better how each bar relates to the set target.

How can I add a horizontal line?

Thanks for all help!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 10:33:27.527356

1 Answer

Sort by » oldest newest most voted

answered 2014-02-13 01:12:40 +0100

m.a.riosv gravatar image

updated 2014-06-13 22:12:43 +0100

You can use the Column and Line type and add an extra column with all data to 60 for the line. So you can easily change the target value.

Edited 2014-06-13

image description

edit flag offensive delete link more


Could you elaborate on that a bit? I don't know what to do from this description.

endolith gravatar imageendolith ( 2014-06-13 17:17:56 +0100 )edit

@endolith: Right-click your chart, and select "Edit". Now open the "Format" menu, and choose "Chart Type..." This will open the dialog displayed in this answer.

Camil Bancioiu gravatar imageCamil Bancioiu ( 2016-07-05 15:06:49 +0100 )edit

Question Tools



Asked: 2014-02-12 16:11:20 +0100

Seen: 5,255 times

Last updated: Jun 13 '14