Chart Design tab and chart data

Adjust the chart settings

When a chart is selected, the Chart Design tab becomes available on the top toolbar. Use it to adjust the chart appearance and settings.

• Chart Elements — click to show or hide individual chart elements: Chart title, Data labels, and Legend.

• Select Data — click to open the Chart data window and manage the data range, legend entries, and axis labels.

• Switch Row/Column — click to swap the chart rows and columns, changing the orientation of the plotted data.

• Chart designs — choose a design from the icon list to apply a preset style to the chart. Click the arrow to expand the list and see all available designs.

• Chart type — click to change the selected chart type and style.

  When you choose Combo Charts, the Chart type window lists chart series and allows choosing the types of charts to combine and selecting data series to place on a secondary axis.

  

• Advanced settings — click to open the Chart — Advanced Settings window. For details, see Chart advanced settings.

• Width and Height — use these fields to set the chart dimensions manually.

• Lock aspect ratio — enable this option to preserve the original proportions of the chart when resizing.

When a 3D chart type is selected, the 3D Rotation button also appears on the Chart Design tab:

• X rotation — set the required value for the X axis rotation using the keyboard or via the Left and Right arrows to the right.

• Y rotation — set the required value for the Y axis rotation using the keyboard or via the Up and Down arrows to the right.

• Perspective — set the required value for depth rotation using the keyboard or via the Narrow field of view and Widen field of view arrows to the right.

• Right Angle Axis — is used to set the right angle axis view.

• Autoscale — check this box to autoscale the depth and height values of the chart, or uncheck this box to set the depth and height values manually.

• Depth (% of base) — set the required depth value using the keyboard or via the arrows.

• Height (% of base) — set the required height value using the keyboard or via the arrows.

• Default Rotation — set the 3D parameters to their default.

  note

  Please note that you cannot edit each element of the chart; the settings will be applied to the chart as a whole.

note

To quickly open the Chart Editor window, you can also double-click the chart in the spreadsheet.

Edit chart data

To edit chart data, click the Select Data button on the Chart Design tab to open the Chart data window directly.

1. Use the Chart data dialog to manage Chart data range, Legend entries (series), Horizontal (category) axis labels and Switch row/column.

   

   • Chart data range — select data for your chart.

     • Click the icon on the right of the Chart data range box to select data range.

       

   • Legend entries (series) — add, edit, or remove legend entries. Type or select series name for legend entries.

     • In Legend entries (series), click Add button.

     • In Edit series, type a new legend entry or click the icon on the right of the Series name box.

       

   • Horizontal (category) axis labels — change text for category labels.

     • In Horizontal (category) axis labels, click Edit.

     • In Axis label range, type the labels you want to add or click the icon on the right of the Axis label range box to select data range.

       

   • Switch row/column — rearrange the worksheet data that is configured in the chart, not in the way that you want it. Switch rows to columns to display data on a different axis.

2. Click OK button to apply the changes and close the window.