Hình 4-118. Các giá trị lớp, màu theo nhóm số điểm màu sắc này, Red nắm bắt các giá trị cao nhất, vàng của những người trung gian, và xanh thấp nhất tất cả trong shadings để phản ánh sự khác biệt tốt trong các giá trị. | CHAPTER 5 THE STUFF OF LEGEND CHARTING IN EXCEL the chart on any object. As a matter of fact clicking a data point will turn the data labels on only for the series of which on which you ve clicked so you re actually better off not clicking directly on the data themselves. However data labels can congest the chart if the data points are numerous Figure 5-53 Figure 5-53. Information overload An excess of data labels You ll think twice about handing that one to your boss. Remember though that you can improve the scenario by recoloring and or changing the size of the numbers. Take any of the prescribed routes to the chart formatting options and make the appropriate changes. Be advised though that you ll have to click on each data series and make the changes to each series individually. The Data Table option already portrayed in Figure 5-36 presents all the data giving rise to the chart. It s a greedy object however and by implementing this option you may find yourself looking at something like this Figure 5-54 Figure 5-54. Bet you didn t know George was two syllables Needs work as they say. Widening the chart would do wonders. 186 CHAPTER 5 THE STUFF OF LEGEND CHARTING IN EXCEL Axes to Grind The Axes button group allows you to redraw certain aspects of the Horizontal and Vertical Axis Figure 555 Figure 5-55. The Axes button group The Vertical Axis options are particularly important. What s called the Primary Horizontal Axis allows you to flip the order of your Horizontal Axis labels and also throw the Vertical Axis to the right edge of the chart Figure 5-56 Figure 5-56. Right-handed Vertical Axis But when your axis works with numerical data as is the case with the Primary Vertical Axis the options look like this Figure 5-57 187 CHAPTER 5 THE STUFF OF LEGEND CHARTING IN EXCEL None Do not display Axis Show Default Axis Display Axis with default order and labels Show Axis in Thousands Display Axis with numbers represented in Thousands Show Axis in Millions Display Axis .
