Page 1 of 1
[Solved] Calc Charts: how to edit Data Labels with a text?
Posted: Wed Aug 26, 2015 9:57 pm
by gselvais
In an X-Y scattered chart, I am trying to replace Single Data Labels by a text ( from cells).
Apparently OpenOffice doesn't allow us to link individual data labels to other cells (and it doesn't let us manually edit the text of a data label). Is there a work-around this barrier?
Re: In Calc Charts, how to edit Data Labels with a text?
Posted: Wed Aug 26, 2015 10:55 pm
by acknak
Greetings and welcome to the community forum!
One way to configure the chart to use a column as data labels:
Under "Data Ranges" assign the column as "Categories" or "Data Labels", then right-click on a data point, Format Data Labels > Data Labels, set "Show Categories" as YES
Re: In Calc Charts, how to edit Data Labels with a text?
Posted: Thu Aug 27, 2015 1:37 am
by acknak
[OP asked for follow-up by PM]
I haven't tried to use the time line template shown in your screen shot (
http://vertex42.com/ExcelArticles/creat ... eline.html) but here's an example using the steps I described above.
Re: In Calc Charts, how to edit Data Labels with a text?
Posted: Thu Aug 27, 2015 5:13 am
by gselvais
That looks great. I'll figure out how to add the vertical "Error Bars" between the Data Point Labels and the X-Axis.
This is "SOLVED"
Thank you