Setting Chart Options
Excel Options allows you to set options for charts in a workbook. When you insert charts into a workbook, you can set options to show data point values or chart element names when you point to (hover) the item on the chart. You can also set an option to have custom formatting and chart data labels follow data points as they move or change in the chart for the current workbook or for all new workbooks (New!).
Change Chart Options
Click the File tab, and then click Options.
In the left pane, click Advanced.
Select or clear ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
