Edit titles or data labels in a chart - Microsoft Support
To edit the contents of a title, click the chart or axis title that you want to change. To edit the contents of a data label, click two times on the data label that you want to change. The first click selects the data labels for the whole data series, and the second click selects the individual data label.
Add, change, or remove error bars in a chart - Microsoft Support
Error bars in charts you create can help you see margins of error and standard deviations at a glance. They can be shown on all data points or data markers in a data series as a standard error amount, a percentage, or a standard deviation. You can set your own values to display the exact error amounts you want.
Add a legend to a chart - Microsoft Support
Learn how to add a legend to a chart, retrieve a missing legend, and adjust its settings. Add, edit, or remove a chart legend in Excel.
Modify chart legend entries - Microsoft Support
When a chart has a legend displayed, you can modify the individual legend entries by editing the corresponding data on the worksheet. For additional editing options, or to modify legend entries without affecting the worksheet data, you can make changes to the legend entries in the Select Data Source dialog box. What do you want to do?
Insert a check mark symbol - Microsoft Support
You can easily insert a check mark (also known as a "tick mark") in Word, Outlook, Excel, or PowerPoint. These marks are static symbols. If you're looking for an interactive check box that you can click to check or uncheck, see: Add a check box or option button (Excel) or Make a checklist in Word.
Vary the colors of same-series data markers in a chart
When you create a single-series chart, all data markers that represent the data points in that data series are displayed in the same color. To use different colors for each data marker, you can vary the colors automatically by using the Vary colors by point or Vary colors by slice option.
Add and format a chart legend - Microsoft Support
Steps for adding and changing the look of a chart legend in Office 2016 for Windows, including customizing the border, the background of the chart legend, and changing and resizing the font used in a chart legend.
Change the plotting order of categories, values, or data series
To change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis. Click a chart. This displays the Chart Tools.
Create a chart from start to finish - Microsoft Support
Learn how to create a chart in Excel and add a trendline. Visualize your data with a column, bar, pie, line, or scatter chart (or graph) in Office.
Lookup and reference functions (reference) - Microsoft Support
For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions. Searches a range or an array and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.
|