Display empty cells, null (#N/A) values, and hidden worksheet …
网页Change the way that empty cells, null (#N/A) values, and hidden rows and columns are displayed in a chart. Click the chart you want to change. Go to Chart Tools on the Ribbon, then on the Design tab, in the Data group, click Select Data. Click Hidden and Empty Cells.
Insert a chart from an Excel spreadsheet into Word
网页The simplest way to insert a chart from an Excel spreadsheet into your Word document is to use the copy and paste commands. You can change the chart, update it, and redesign it without ever leaving Word. If you change the data in …
Available chart types in Office - Microsoft Support
网页The sunburst chart is ideal for displaying hierarchical data and can be plotted when empty (blank) cells exist within the hierarchal structure . Each level of the hierarchy is represented by one ring or circle with the innermost circle as the top of the hierarchy.
Create a chart from start to finish - Microsoft Support
网页Charts help you visualize your data in a way that creates maximum impact on your audience. Learn to create a chart and add a trendline. You can start your document from a recommended chart or choose one from our collection of pre-built chart templates. Select data for the chart.
Display empty cells, null (#N/A) values, and hidden worksheet data in …
网页Change the way that empty cells, null (#N/A) values, and hidden rows and columns are displayed in a chart. Click the chart you want to change. Go to Chart Tools on the Ribbon, then on the Design tab, in the Data group, click Select Data. Click Hidden and Empty Cells.
Show or hide a chart legend or data table - Microsoft Support
网页You can hide or show the legend of a chart. You can also show a data table for a line chart, area chart, column chart, or bar chart.
Add or remove series lines, drop lines, high-low lines, or up …
网页You can add predefined lines or bars to charts in several apps for Office. By adding lines, including series lines, drop lines, high-low lines, and up-down bars, to specific chart can help you analyze the data that is displayed.
Update the data in an existing chart - Microsoft Support
网页Update the data in an existing chart. If you need to change data in a chart, you can do it from its source. Try it! Changes you make will instantly show up in the chart. Right-click the item you want to change and input the data--or type a new heading--and press Enter to display it in the chart.
Save a custom chart as a template - Microsoft Support
网页To reuse a chart you customized, you can save it as a chart template (*.crtx). Right-click the chart, and select Save as Template. In the File name box, type an appropriate name for the chart template. Click Save.
Change the display of chart axes - Microsoft Support
网页On a chart, click the horizontal (category) axis that you want to change, or do the following to select the axis from a list of chart elements: Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
Explode or expand a pie chart - Microsoft Support
网页To make parts of a pie chart stand out without changing the underlying data, you can pull out an individual slice, pull the whole pie apart, or enlarge or stack whole sections by using a pie or bar of pie chart.