![]() To do that, select the chart, and double-click the selection border. I like this one, Style 11, because it emphasizes the trendlines and moves the legend to the top. I’ll point to a style to see a preview on the chart. That’s a quick way to get chart formatting. Note that the current trendline is selected in the chart - the selection handles appear at either end - and, in the pane, I can click Fill & Line or Effects to choose more formatting options for the line.īut for now, let’s click X to close this pane, and instead click Chart Styles to see the available styles for the chart. This time, I’ll choose Seattle and click OK.Īn orange trendline now runs through the Seattle data, and the Format Trendline pane opens. I have already checked Trendline, so I’ll point to it, click its arrow, and then click More Options. I’ll leave New York selected and click OK.Ī trendline appears for the New York data and shows as a blue dotted line. We are prompted to choose one of the series, New York or Seattle. Let’s do a bit more with the data and check Trendline. I’ll check the Data Labels box to display these. So, I’ll click CHART ELEMENTS and point to Data Labels.Įxact amounts appear above the markers, showing our data for Average Precipitation. Now, the chart shows incremental values for inches of precipitation.īut I’d like to show the exact amounts at the markers. It is selected, so I can type my label, and I’ll type "Inches". ![]() We click CHART ELEMENTS, point to Axis Titles, click the arrow next to it, and check Primary Vertical.Ī text box appears for the vertical axis. The default value for Decimal places is 2, and the values in the chart now show two decimal places. Under Category, I’ll click the arrow and change the General formatting to Number. In the pane, I’ll scroll to NUMBER and click to expand its options. So, in the chart, I’ll point to one of the data values and click to select the vertical axis. The Format Axis pane opens and the horizontal axis is selected in the chart. ![]() Then I’ll click the top one, Chart Elements, and I’ll point to Axes, click the arrow that appears, and click More Options. So, I’ll click to select the chart and look for these icons. Next, I’d like to change the formatting of the data values, so that they include decimal places. Then, I’ll click the Chart Title, select the text, and type a new title "Average Precipitation". Now, let’s customize the chart, so it has the details and style we want. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |