- #HOW TO SHOW SIGNIFICANT DIGITS ON AN EXCEL GRAPH AXIS LABEL HOW TO#
- #HOW TO SHOW SIGNIFICANT DIGITS ON AN EXCEL GRAPH AXIS LABEL SERIES#
If for some reason the title was not added automatically, then click anywhere within the graph for the Chart Tools tabs to appear. The detailed steps are explained in Linking axis titles to a certain cell on the sheet. You can also link the chart title to some cell on the sheet, so that it gets updated automatically every time the liked cell is updated. To change the title text, simply select that box and type your title: In these Excel versions, a chart is already inserted with the default " Chart Title". And for the rest of the tutorial, we will focus on the most recent versions of Excel.
#HOW TO SHOW SIGNIFICANT DIGITS ON AN EXCEL GRAPH AXIS LABEL HOW TO#
This section demonstrates how to insert the chart title in different Excel versions so that you know where the main chart features reside. For immediate access to the relevant Format Chart pane options, double click the corresponding element in the chart.Īrmed with this basic knowledge, let's see how you can modify different chart elements to make your Excel graph look exactly the way you'd like it to look.
Microsoft has really made a big effort to simplify the process and place the customization options within easy reach. In modern versions of Excel, customizing charts is easy and fun. In this example, that doesn’t quite work you’ll need to manually add two text boxes.After you have created a chart in Excel, what's the first thing you usually want to do with it? Make the graph look exactly the way you've pictured it in your mind!
#HOW TO SHOW SIGNIFICANT DIGITS ON AN EXCEL GRAPH AXIS LABEL 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: I recently discussed four options for labeling line graphs.