In this case, starting at cell A3 = Layer 1, it would named each cell Layer 2, and then Layer 3, until the layer number matches the value in E5. Problem is, I can't find a way to set a variable and retrieve it's value in a single cell's forumula, and I can't use nested formulas either (SUM(Var1:E1) where Var1 is the string E2 or something like that)

The amount of cells in that row would change dynamically with whatever is set in E5 If E5 = 5, and the start point is A3, it would fill A3 through A8 with '25' or whatever desired string or formula.įor me, it's ='Layer ' & ROW() - 2 and I want to fill every cell in that column to a range determined in E5.

If cell E4 = 25, fill the cells in the desired column below a certain point with '25' for x amount of rows. So, fill x amount of cells with a value set in, say, E4. Depending on how close your points are etc., they might overlap each other the Format Data Labels dialog box has options for font, label placement and rotation which could be useful.I'm trying to dynamically fill a range of cells in a column based on a number in another cell. Once you are on the dialog for selecting Data Series and Data Ranges, select any of the Data Ranges, then define a range for the 'Data Labels' (the text you want next to each point) by entering it or using the tool that allows you to select it from the spreadsheet.ġ) Select the points, right click and click 'Insert Data Labels', then right click again and click 'Format Data Labels or Then have the 'First row as label' checked or unchecked as appropriate and click Next. Select the columns that contain the data you want to plot (but not the labels) and create a chart (Chart button or Insert->Chart.).Ĭhoose the XY (Scatter) chart type and click Next. (Tested in LibreOffice 4.0.4.2 but likely to work in later versions.) It can be done this won't show a label on hover, but will put the text in the plot itself.

Libreoffice spreadsheet