You can use these buttons and their drop-down menus to create these types and styles of charts. To the right of the Recommended Charts button on the ribbon, you'll see this: We'll discuss all of these options later in this article. The tools shown above will help you customize your charts. You'll also notice the Chart Tools Format tab opens in the Ribbon: The chart is embedded in your worksheet for you: On the right is a preview of what the chart will look like with your data.Ĭhoose the chart you want to use, then click OK. On the left side of this dialog box you'll find all the chart recommendations. When you click on the Recommended Charts button, a dialog box opens, like the one pictured below.īased on your data, Excel recommends a chart for you to use. To create a chart this way, first select the data you want to put into a chart. This is under the Insert tab on the Ribbon in the Charts group (as pictured above). That was a great tool and a great help, but Excel 2013 offers you something even better: the Recommended Charts tool. To use a gradient effect for the selected fill color, click Gradient, and then click the gradient style that you want to use.įor additional gradient styles, click More Gradients, and then in the Format Chart Area pane, under Fill, click the gradient options that you want to use.In prior versions of Excel, you had the Chart Wizard to help you create charts. In the Colors dialog box, use the available options to pick a color, and then click OK. To use a fill color that is not available under Theme Colors or Standard Colors, click More Fill Colors. To use a different fill color, under Theme Colors or Standard Colors, click the color that you want to use. On the Format tab, in the chart elements dropdown, select the chart element that you want to use. You cannot use shape fill to format lines in a chart (such as gridlines, axes, trendlines, or error bars). You can fill a selected shape (such as data markers, titles, data labels, or a legend) with a solid color, gradient, picture, or texture. You cannot use arrow styles for borders.įor additional arrow style or border style options, click More Arrows, and then click the arrow setting that you want to use. To add arrows to lines, click Arrows, and then click the arrow style that you want to use. To use a dashed line or border, click Dashes, and then click the dash type that you want to use.įor additional dash-type options, click More Lines, and then click the dash type that you want to use. To change the weight of a line or border, click Weight, and then click the line weight that you want to use.įor additional line style or border style options, click More Lines, and then click the line style or border style options that you want to use. In the Colors dialog box, specify the color that you want to use on the Standard or Custom tab, and then click OK.Ĭustom outline colors that you create are added under Recent Colors so that you can use them again. To use an outline color that is not available under Theme Colors or Standard Colors, click More Outline Colors. Note: If the selected element is a line, the line will no longer be visible on the chart. To use a texture fill, click Texture, and then click the texture that you want to use. To use a gradient effect for the selected fill color, click Gradient, and then under Variations, click the gradient style that you want to use.įor additional gradient styles, click More Gradients, and then in the Fill category, click the gradient options that you want to use. In the Insert Picture dialog box, click the picture that you want to use, and then click Insert. To fill the shape with a picture, click Picture. In the Colors dialog box, specify the color that you want to use on the Standard or Custom tab, and then click OK.Ĭustom fill colors that you create are added under Recent Colors so that you can use them again. To remove the color from the selected chart element, click No Fill. When you point to colors that you may want to use, the selected chart element will be displayed in that color on the chart. Tip: Before you apply a different color, you can quickly preview how that color affects the chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |