Use custom formats in an Excel chart’s axis and data labels

Takeaway: Incorporating a customized format to a chart’s axis and data labels can quickly flip ordinary info into data.

Charts let us to swiftly assimilate knowledge into information. With a quick glance, you can discern numerous essential specifics about your information, with out viewing rows and rows of detail values. Once the data’s in a chart, you can additional increase the knowledge with formatting. For instance, the next two graphs demonstrate the variation between no additional formatting and a basic custom made range format utilized to the two the axis and the data labels. It’s subtle, but it nevertheless attracts your focus to a certain stage, without having truly saying, “Hey… search at this!” or drawing a massive red arrow.

Now, let us suppose that almost everything above $ 325 displays a profit, almost everything beneath $ 325 is a break-even enterprise. Every person may know this previously, but modifying the coloration of the axis values and the data labels makes revenue objects stand out.

Producing the impact is easy. 1st, let us transform the axis quantity format, as follows:

1. Appropriate-click on the Axis place and choose Format Axis from the context menu. If you really don’t see Format Axis, right-click one more spot.
2. Pick Quantity in the left pane. (In Excel 2003, click on the Amount tab.)
3. Click Customized in the Group listing.
4. Enter the following format: [Blue][&lt325]$ [Green][&gt=325]$ . (The period of time is not portion of the format.)
5. Click on Add (not in Excel 2003).
6. Click on Near (Ok in Excel 2003).

The blue numbers indicate break-even income the green numbers display individuals revenue that make a gain. Nonetheless, it still is not a comprehensive photograph since the $ 326 point is just a hair previously mentioned the break-even position, but you really do not get that message. That is why you may want to add the very same custom amount format to the information labels, as follows:

1. Correct-click a series and choose Format Information Labels from the context menu. If you really don’t see that selection, appropriate-click on again—you’ve chosen the improper component.
2. Repeat steps two via 6 previously mentioned.

You will almost certainly want to format all of the sequence, but in this case in point, only the 1 sequence changes. The break-even point is not explicit, but formatting the knowledge labels provides a second layer of info for people values that fall among the actual break-even point and the first formatted axis worth.