Ask Your Question
0

Edit legend on chart [closed]

asked 2014-10-27 22:29:34 +0100

Erii gravatar image

updated 2014-10-27 22:31:23 +0100

Hello, I have a little problem. I would like to add to legend of chart a value of cell. Example I have 3 columns (low, good, high) with value 6%, 30% and 64%. Now in legend i have only:

[] low 
[] good 
[] high

I want:

[] low (6%)
[] good (30%)
[] high (64%)
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-03-05 18:34:09.250013

1 Answer

Sort by » oldest newest most voted
1

answered 2014-10-28 06:27:28 +0100

ROSt52 gravatar image

The point is that you need two cells for one legend name. One cell contains "low" and the other contains "(6%)"

Open the following dialog window and adjust the range for each "Name" to contain the two cells for one of you legend names you want.

image description

Next picture shows how data and legend name are arranged. Note that for simplicity I did to prepare an x-axis but Calc creates a default x-axis.

image description

edit flag offensive delete link more

Comments

Out of curiosity: Who does insert the space between "low" and "(6%)"? Ist it entered into E7?

Lupp gravatar imageLupp ( 2014-10-28 12:58:46 +0100 )edit

@Lupp - Calc does it by itself. Nice feature.

ROSt52 gravatar imageROSt52 ( 2014-11-01 11:56:23 +0100 )edit

@ROSt52 And what to do if I dislike the space? I want control. Had enough bother with nice features.

Lupp gravatar imageLupp ( 2014-11-01 12:56:50 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2014-10-27 22:29:34 +0100

Seen: 1,081 times

Last updated: Oct 28 '14