Set the properties of chart components such as chart data, type, labels, and gridlines.
More Information
Data
- Edit Data
Enter the data you want to display as a chart or select a range of data.
- Switch Row/Column
Display a chart by switching row and column data.
Chart Type
Change the current chart to the chart selected in the list.
- Chart Style
Change the chart style by selecting the desired one from the Chart Theme list. Once you have selected a theme, you can choose a style with additional properties such as line, shadow, or background color.
Chart Labels
- Data Labels
Select whether or not to display labels for each series and item in the chart , and specify the display position. This may not be available depending on the chart type selected.
- Legend
Select whether or not to display the chart legend, and specify the display position.
- Edit
Enter or edit the Chart Title and Vertical Axis Title or Horizontal Axis Title.
Gridlines
- Horizontal/Vertical
Select whether to display major/minor horizontal and vertical gridlines.