Change the chart type of an existing chart - Microsoft Support
网页To change the Clustered Column to Pie, select your chart. On the Chart Design tab, click Change Chart Type > Pie > Pie . Your new chart type will show in your spreadsheet.
Switch between stacked and clustered columns in a 3D Maps …
网页Use clustered columns to compare data across both categories and data series. For example, if you have entries like Strongly Agree, Agree, Neutral, Disagree, and Strongly Disagree, by customer segment. Switch between a stacked or clustered column chart in 3D Maps in Excel 2016 for Windows.
Available chart types in Office - Microsoft Support
网页Clustered bar and 3-D Clustered bar chart Compares values across categories. In a clustered bar chart, the categories are typically organized along the vertical axis, and the values along the horizontal axis.
Change the plotting order of categories, values, or data series
网页Reverse the plotting order of categories or values in a chart. On a chart, do one of the following: To change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis.
Change the display of a 3-D chart - Microsoft Support
网页To make a 3-D chart, such as a 3-D column, 3-D line, or 3-D surface chart) easier to read, you can change the 3-D format, rotation, and scaling of the chart. For charts that display chart elements in 3-D without using a third, depth axis (such as a pie in 3-D, bar in 3-D, or stacked area in 3-D chart), you can change the 3-D format of the 3-D ...
Change the chart type of an existing chart - Microsoft Support
网页To change the Clustered Column to Pie, select your chart. On the Chart Design tab, click Change Chart Type > Pie > Pie . Your new chart type will show in your spreadsheet.
Change how rows and columns of data are plotted in a chart
网页Change the way that data is plotted. Click anywhere in the chart that contains the data series that you want to plot on different axes. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Switch Row/Column.
Change legend names - Microsoft Support
网页The legend name in the chart updates to the new legend name in your data. Certain charts, such as Clustered Columns, also use the cells to the left of each row as legend names. You can edit legend names the same way. Change the legend name using select data.
Create a chart from start to finish - Microsoft Support
网页Clustered column A clustered column chart shows values in 2-D columns. Use this chart when you have categories that represent: Ranges of values (for example, item counts).
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.
Change the display of chart axes - Microsoft Support
网页Value axes provide a variety of options, such as setting the scale to logarithmic. Other chart types, such as column, line, and area charts, show numeric values on the vertical (value) axis only and show textual groupings (or categories) on the horizontal axis.