Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 06 Nov 2016 00:49:02 +0100How to choose data range for data labels in graph for data points on graph in calc?https://ask.libreoffice.org/en/question/81172/how-to-choose-data-range-for-data-labels-in-graph-for-data-points-on-graph-in-calc/On a spreadsheet I have 3 columns of data in columns B, C and D respectively with one row above them labelling the column Product, Price per Kilo and Price per Product. I attempted to create a x-y scatter of the C and D columns to have Price per Kilo against Price per Product. This all worked fine. I then tried to label the data points with the corresponding Product name in the B column. I tried entering the corresponding range into the Data Labels column but this did not change the look of the graph. I then tried selecting the data points on the graph and chose Insert Data Labels, this inserted Labels onto each point but for the same data as the Y axis / Column D and not the Data Labels range I selected in the Data Ranges' Data Labels. I then tried changing the Data Ranges to some dummy value and this did not propagate over to changing the value on the Data Labels shown on the graph either, it seems regardless of what I set the actual Data Ranges and Labels to that the plot on the graph insists on using Column D to produce the labels on each point. At this point I'm completely out of ideas and couldn't find any similar problem on the web with a quick search. Any ideas?
<img>http://i.imgur.com/SeXpv0i.png</img>
<img>http://i.imgur.com/zpyBujN.png</img>Sat, 05 Nov 2016 14:09:55 +0100https://ask.libreoffice.org/en/question/81172/how-to-choose-data-range-for-data-labels-in-graph-for-data-points-on-graph-in-calc/Answer by Skeletonxf for <p>On a spreadsheet I have 3 columns of data in columns B, C and D respectively with one row above them labelling the column Product, Price per Kilo and Price per Product. I attempted to create a x-y scatter of the C and D columns to have Price per Kilo against Price per Product. This all worked fine. I then tried to label the data points with the corresponding Product name in the B column. I tried entering the corresponding range into the Data Labels column but this did not change the look of the graph. I then tried selecting the data points on the graph and chose Insert Data Labels, this inserted Labels onto each point but for the same data as the Y axis / Column D and not the Data Labels range I selected in the Data Ranges' Data Labels. I then tried changing the Data Ranges to some dummy value and this did not propagate over to changing the value on the Data Labels shown on the graph either, it seems regardless of what I set the actual Data Ranges and Labels to that the plot on the graph insists on using Column D to produce the labels on each point. At this point I'm completely out of ideas and couldn't find any similar problem on the web with a quick search. Any ideas?</p>
<p><img><a href="http://i.imgur.com/SeXpv0i.png">http://i.imgur.com/SeXpv0i.png</a></p>
<p><img><a href="http://i.imgur.com/zpyBujN.png">http://i.imgur.com/zpyBujN.png</a></p>
https://ask.libreoffice.org/en/question/81172/how-to-choose-data-range-for-data-labels-in-graph-for-data-points-on-graph-in-calc/?answer=81215#post-id-81215Completely works thank you. Calc's UI is so confusing.Sun, 06 Nov 2016 00:49:02 +0100https://ask.libreoffice.org/en/question/81172/how-to-choose-data-range-for-data-labels-in-graph-for-data-points-on-graph-in-calc/?answer=81215#post-id-81215Answer by Regina for <p>On a spreadsheet I have 3 columns of data in columns B, C and D respectively with one row above them labelling the column Product, Price per Kilo and Price per Product. I attempted to create a x-y scatter of the C and D columns to have Price per Kilo against Price per Product. This all worked fine. I then tried to label the data points with the corresponding Product name in the B column. I tried entering the corresponding range into the Data Labels column but this did not change the look of the graph. I then tried selecting the data points on the graph and chose Insert Data Labels, this inserted Labels onto each point but for the same data as the Y axis / Column D and not the Data Labels range I selected in the Data Ranges' Data Labels. I then tried changing the Data Ranges to some dummy value and this did not propagate over to changing the value on the Data Labels shown on the graph either, it seems regardless of what I set the actual Data Ranges and Labels to that the plot on the graph insists on using Column D to produce the labels on each point. At this point I'm completely out of ideas and couldn't find any similar problem on the web with a quick search. Any ideas?</p>
<p><img><a href="http://i.imgur.com/SeXpv0i.png">http://i.imgur.com/SeXpv0i.png</a></p>
<p><img><a href="http://i.imgur.com/zpyBujN.png">http://i.imgur.com/zpyBujN.png</a></p>
https://ask.libreoffice.org/en/question/81172/how-to-choose-data-range-for-data-labels-in-graph-for-data-points-on-graph-in-calc/?answer=81183#post-id-81183In edit mode of the chart goto Insert > Data Labels. You get a dialog with a dialog page "Data Labels". There you have to check what you want to be shown as "Label". In your case you need to check "Show Category".Sat, 05 Nov 2016 18:06:48 +0100https://ask.libreoffice.org/en/question/81172/how-to-choose-data-range-for-data-labels-in-graph-for-data-points-on-graph-in-calc/?answer=81183#post-id-81183