This menu lets you filter the data is displayed in the chart. Notice that chart styles and colors available in the paint brush icon are also available on the Design tab of the ribbon, Under Chart Tools.įinally, the filter icon is called Chart Filters. To apply, just select and click away from the chart. Click the color tab to see the colors available. The Paint brush icon also allows you to apply color schemes. Use the scrollbar to see your chart previewed with each style. The paint brush icon is named chart styles and let's you access chart styles and colors. Excel will then display a menu of available sub options.įor example, I can use that menu to move the data labels outside the bars, or inside the bars. To access a second level click the arrow to the right of a given element. Here you'll find options for a long list of chart elements, including axis and axis titles, the chart title, Data labels, Data table, error bars, gridlines, legend, and trendlines.įor example, to add data labels to this chart, click the plus icon, then check Data labels. This menu lets you quickly enable and disable chart elements. When you click the icon, you'll see a list of common chart elements displayed as checkboxes. The plus icon is actually a fly out menu called Chart Elements. Whenever you select a chart in later versions of Excel, you'll see three icons appear at the upper right edge: the plus icon, the paint brush icon, and the filter icon. This menus have names, but you'll see them as the plus icon, the paint brush icon, and the filter icon. In this video, we'll look at the three special menus that appear whenever you select a chart in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |