![]() There are no formatting choices in the submenu.Ī text box appears centered under the horizontal axis Hover over Axis Titles to expand the submenu.With the chart selected, on the ribbon tab Chart Tools: Design, click the Add Chart Element button.If you have trouble with the selecting, you canĪre many parts that can be on a chart, but they may not be on the This is a good method for editing text in place. It shows in the text box after youīetter and has more appropriate capitalization.Īlternate method: Select the title's text box and then drag Your typing will replace the existing text. Press the ENTER key or click out of the chart. Which will show in the Formula Bar but the chart title does not change yet. Click on title of the chart, 'Number of people'.īox selected, not the text.You can edit the title and axis labels on a chart directly on theĬhart or in the Formula bar. ![]() Your chart to its previous state or close without saving and reopen the document. You canįormat many features, including background and lines. You can hide or reveal any of these parts of a chart. Try out choices for formatting chart elements from the ribbon, like Labels, Axes, and.The text box is gone and the plot area expands to take up Click on the text box containing Week to select it.Open the menu of formatting choices again for Legend and click on None.Īlternate method: Click the legend on the chart.Try out various combinations of Fill, Borders, Effects, etc.Ĭurrent chart is not really helped by a legend at all since there is only.The icons show a sample of the legend's position. Do you like this effect? Does it make the chart harder to read?Įxcel 2013, 2016: On the ribbon tab Chart Tools: Design click the button Add Chart Element and hover over Legend to see the submenu. This lets the fill show through the Plot Area, too. But Excel 20 change the Plot Area background to None when you apply a Chart Area fill. ![]() In Excel 20 the Plot Area still has a white background. Much prettier than a plain white background! Of course aīusy or dark image could make it hard to read your Click on the Texture button to open its gallery.įor once the choices are the same in Excel 2007, 2010, 2013, and 2016.Ĭhart now shows a repeating blue textured image as aīackground.More choices appear below the radio buttons. ![]() You can even use your own pictures as a background. Solid colors, gradients, pictures, textures, and patterns. Live Preview works once you have made a selection. Try out other choices on the Fill page forįills. Solution: Right click beside the title text box but not in that text box. You clicked on a chart part or in the Plot Area instead of a blank area around the chart. The Format Chart Area dialog or pane opens to its first page,įill, with the Automatic radio button selected. Right click in a blank area around the chart and choose Format Chart Area… from the Or image can make your chart more attractive. The solid white background is good for many charts, but sometimes a gradient color, pattern, You colored Week 2 differently because it had the highest number of tickets Much since there is only one series of columns. All the other wedges are converted to the default color, which is different in Excel 2013 and in Excel 2016. It retained the color you assigned to its pie wedge. The changes you made are kept, like the title text, the added text box 'Week', and the data point color.ĭata Point Labels: The data points are now labeled with the values they represent instead of the percentages that were in the pie chart.Ĭolors: What was the 19% wedge for Week 2 is now the purple column, labeled 23. The chart is redrawn as a set of columns, using the default settings for this chart type. Select Column, which is Excel's default chart type,Īnd choose the first sub-type, Clustered Column.
0 Comments
Leave a Reply. |