In this example, that doesn’t quite work you’ll need to manually add two text boxes.
#How to get axes labels on excel for a mac series
To add the Organization A and Organization B text, I would *usually* click Format Data Labels and check the box next to Series Name. I often adjust the label colors so that the labels match the line (maroon numbers to match the maroon line, orange numbers to match the orange line). You might enlarge the label text and make that text bold so that it stands out against the gray axis labels. Finally, fill the label with white so that the text is legible.Ĭontinue formatting a bit more. Adjust the label position so that the labels are centered on top of each data point. Then, do the same thing to the orange line: Add data labels. Go to Shape Fill (the paint can icon) and fill each label with a white background. So the labels are totally unreadable because they’ve got a line running through them.Ĭlick on the labels again so that a square appears around the outside of the labels. In the Format Data Labels editing window, adjust the Label Position.īy default the labels appear to the right of each data point.Ĭlick on Center so that the labels appear right on top of each point. Then, right-click on any of those data labels. You’ll see little squares around each data point. Your unformatted labels will appear to the right of each data point:Ĭlick just once on any of those data labels. Right-click on top of one of those circular data points. You might even add light gray tick marks along the x-axis.Ĭlick anywhere along the line, just once, and you’ll see little circles on top of each data point: You’ll get a 1990s-era default line chart:Īdjust the y-axis so that the grid lines don’t appear quite so often (e.g., every 50 units rather than every 20 units).Īpply a custom color palette (colors that match the organization’s look and feel rather than Excel’s blue and orange). Highlight the entire data table (A1 through H3), go to the Insert tab, and click on the line chart icon. There’s been a lot of interest in this labeling technique, so here’s your step-by-step tutorial! A personal favorite is to place the labels directly through the data points, like this: Double-click on the Thousands label to edit the label, as desired, then drag it to any desired position.I recently discussed four options for labeling line graphs. Using the Display Units drop-down list, choose Thousands.Įxcel changes the axis values so only the thousands portion is displayed, and inserts a label saying Thousands.The Scale tab of the Format Axis dialog box. If you'd prefer to not add the additional label, you can always use a format of "0,K" (without the quote marks) in step 5.Ī different way to approach the problem is with these steps, which works in Excel 2000, Excel 2002, and Excel 2003: You can then add another label, as desired, that indicates the values are expressed in thousands. Only the thousands portion of the values in the axis should be displayed. In the Type box, enter a zero followed by a comma.In turn, select the bottom and top vertical axes. We want the Rating labels at the left side of the chart, and we’ll place the numerical axis at the right before we hide it. The Number tab of the Format Axis dialog box. In Excel 2003 go to the Chart menu, choose Chart Options, and check the Category (X) Axis checkmark. Make sure the Number tab is displayed.(If double-clicking doesn't work, right-click the axis and choose Format Axis from the resulting Context menu.) You should see the Format Axis dialog box. Double-click the axis you want to scale.Create your chart as you normally would.You can very easily change the axis scale by simply modifying how the values on the axis are displayed. A note could then be made in a label that indicates the axis values are displayed in thousands. For instance, if the values along an axis ranged from 0 to 80,000, you may want to have only the thousands portion of each value displayed on the axis. It is very common for charts to use some sort of "shorthand" for values placed along an axis.
0 kommentar(er)
