![]() ![]() By default, Excel displays the X axis labels just below the $0 m gridline, not below the plot area. 2: Position X axis labelsĪ negative value can seemingly displace the X axis labels. In the end, the reader’s perception might be all you’re changing, but consider reducing lengthy Y axis values for both space considerations and readability when possible. When you update the source values, check the axis values before printing and distributing, just to make sure the custom format accommodates the new values. ![]() In this case, I chose the 0 placeholder instead of # because 0 displays a 0 value at the 0 gridline. The \m component displays a literal lowercase m. This particular combination will display all digits to the left of the second thousands separator. Figure D Enter this custom format to shorten the Y axis labels. Figure C A custom format shortens the labels. ![]() Click Close (OK in Excel 2003) to see the custom format at work (Figure C).įigure B These Y axis labels are too long.Enter the custom format code $0, \m, as shown in Figure D.Right-click the Y axis (try right-clicking one of the labels) and choose Format Axis from the resulting context menu.In this case, a custom format shortens the labels. It certainly isn’t horrible, but Figure C is better. For example, Figure B shows long Y axis values. Large numbers on the Y axis require a lot of space. Figure A Charting this data is easy, but Excel offers many ways to enhance the initial results. From the Column drop-down in the Charts group, choose Clustered Column (the first option). To create the example column graph, select A2:E6 and then click the Insert tab. Note: This article is also available as a PDF download.įigure A shows the data source for all the example graphs, but these techniques work with almost all chart types. They’ll have no trouble applying these simple techniques. The following tips are incredibly easy to implement, so you can share them with your users. There are many ways to enhance a chart, not for the sake of enhancing, but to emphasis the chart’s point or purpose or to improve readability. You select some values, click a button… and you have a chart. With a few simple tweaks, you can make your Excel charts easier to interpret and convey data in a more compelling and meaningful way.Įxcel’s charting features are powerful, flexible, and easy to implement. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |