badlogo.blogg.se - Excel graph axis label text

But I used a custom number format for the axis, which consisted of several space characters enclosed in double quotes. You can select None for axis labels, and then resize the plot area to make room for the custom labels created above.

Use a third-party add-in like Rob Bovey's free Chart Labeler from.

Link each label to the desired cell: select the labels (one click), select the desired label (second click), type = in the formula bar, select the cell, press Enter, repeat for all labels.

Manually type the desired text into the labels.

If you don't have Excel 2013, you don't have this option, but you could I formatted the labels so they appear to the left of the points, and so they used the Value from Cells option, based on the labels in I2:I5 (middle left chart below). I added data labels to the XY series, shown in orange to distinguish them from the black axis labels (top right chart below). The 0.5 values in column G make the points line up with the vertical axis of the chart.

I formatted the XY series, and changed the axis to Primary (top left chart below). The XY scatter series is on the secondary axis, also not too useful. I right-clicked the added series, picked Change Series Chart Type from the pop-up menu, and changed just this series to an XY scatter type (bottom right chart). This has added another set of columns (bottom left chart), not so useful. I selected and copied the green shaded range in the second data range, selected the chart, and used Paste Special to add the data to the chart, using the settings shown in the dialog overlying the top right chart. I made a column chart (don't know what type of chart you want, but this technique is widely applicable) using the yellow shaded range in the first data range (top left chart). You can use a lookup formula for this, for example, the formula in D2 is:

I inserted a column "Value" (blue text) in your data range that has the Y value corresponding to the label in your "Data" column. I started with your data, and I added a small lookup table.