Right-click inside the text box and then click the formatting options that you want. You can also use the formatting buttons on the Ribbon (Home tab, Font group). To format the whole title, you can right-click it, click Format Chart Title, and then select the formatting options that you want.
How do I edit data in a graph in Word?
How do you edit data in a graph?
- On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
- Double-tap the chart you want to edit.
- Tap Edit chart.
- Choose from: Type: Change the chart type. Legend: Change the legend location. Titles: Change the chart and axis titles. …
- When you're done, tap Done .
How do you edit labels on a graph?
- Right-click the category labels you want to change, and click Select Data.
- In the Horizontal (Category) Axis Labels box, click Edit.
- In the Axis label range box, enter the labels you want to use, separated by commas.
How do you name a series in Excel?
- Right-click the chart with the data series you want to rename, and click Select Data.
- In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit.
- In the Series name box, type the name you want to use.
How do you change the font on a graph?
To change the text font for any chart element, such as a title or axis, right–click the element, and then click Font. When the Font box appears make the changes you want. Here’s an example—suppose you want to change the font size of the chart title. Right click the chart title and click Font.
How do you add a title in Excel?
On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text.
How do I remove a legend in Excel?
Show or hide a legend
On the Layout tab, in the Labels group, click Legend. Do one of the following: To hide the legend, click None. Tip: To quickly remove a legend or a legend entry from a chart, you can select it, and then press DELETE.
How do I rename a series in Excel?
- Right-click the chart with the data series you want to rename, and click Select Data.
- In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit.
- In the Series name box, type the name you want to use.
How do I hide the title of a chart in Excel?
- Click on the chart.
- Select the + sign to the top-right of the chart.
- Uncheck the checkbox next to Chart Title.
How do I color labels in Excel?
To change the labels’ font and background color, select them, go to the Format tab on the ribbon, and choose the formatting options you want.
How do I edit a graph in Excel?
Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK.
How do I change the color of a bar graph in Excel?
…
Change the color of a chart
- Click the chart you want to change.
- In the upper right corner, next to the chart, click Chart Styles .
- Click Color and pick the color scheme you want.
How do I edit text in a chart in Word?
Right-click inside the text box and then click the formatting options that you want. You can also use the formatting buttons on the Ribbon (Home tab, Font group). To format the whole title, you can right-click it, click Format Chart Title, and then select the formatting options that you want.
How do you edit a graph in Word?
On the Insert tab, in the Illustrations group, click Chart. In the Insert Chart dialog box, click the arrows to scroll through the chart types. Select the type of chart that you want and then click OK.
How do I edit data in Excel chart?
Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK.
How do I wrap text in Excel?
- In a worksheet, select the cells that you want to format.
- On the Home tab, in the Alignment group, click Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.) Notes:
How do I hide the title of a chart in Word?
To remove a chart title, on the Layout tab, in the Labels group, click Chart Title, and then click None.
How do I change the angle of a slice in Excel?
Right-click any slice of the pie chart > Format Data Series. In the Format Data Point pane in the Angle of first slice box, replace 0 with 120 and press Enter.
How to create a pie chart in Excel?
Click Insert > Chart. Click Pie and then double-click the pie chart you want. In the spreadsheet that appears, replace the placeholder data with your own information. For more information about how pie chart data should be arranged, see Data for pie charts.
How do I remove a legend in Powerpoint?
On the Layout tab, in the Labels group, click Legend. Do one of the following: To hide the legend, click None. Tip: To quickly remove a legend or a legend entry from a chart, you can select it, and then press DELETE.
How do you explode a slice of a pie chart in Excel?
Right-click the pie chart, then click Format Data Series. Drag the Pie Explosion slider to increase the separation, or enter a number in the percentage box.
How do I hide the title of a chart?
- Click on the chart.
- Select the + sign to the top-right of the chart.
- Uncheck the checkbox next to Chart Title.
How do you name bars in Excel?
- Select your chart in Excel, and click Design > Select Data.
- Click on the legend name you want to change in the Select Data Source dialog box, and click Edit. …
- Type a legend name into the Series name text box, and click OK.
How do I lock a chart in Word?
- Right-click on your chart.
- From the resulting menu, choose Wrap Text, then pick any wrap mode except “In Line with Text.”
- Draw your lines, text boxes, whatever. …
- Select the chart with a single click, then Shift+click each additional item you wish to group.
How do I remove duplicates in Excel?
- Select the range of cells that has duplicate values you want to remove. Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.
- Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates. …
- Click OK.