Chart

Modified on Fri, Nov 21 at 5:31 PM

You can make data into a graph to display data changes that will be instantly recognizable.


Inserting a chart

Perform the following to insert a chart.

  1. Click the Chart toolbox_icon_chart.png icon on the Menu Bar. Or click Insert-Chart.
  2. Select the chart type on the Insert Chart dialog box.

    cell_chart.png

  3. Enter data in the Edit Chart dialog box and close it.
  4. Check if the chart looks as you intended.


Switching row/column

To set chart data direction by row or column, do the following:

  1. Select the chart you want to switch row/column data.
  2. In the Chart task pane at the right, click the Switch Row/Column icon_row_column.png icon.


Adding chart components

To add components to your chart such as data labels and gridlines, do the following:

  1. Select the chart you want to add components to.
  2. In the Chart task pane at the right, click the icon_expand.png icon of Data Labels under Chart Labels, and then select the location from the list. 

    task_pane_chart.png

  3. In the Chart task pane, click to select the Hozontal or Vertical gridlines icon you want to display under Gridlines.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article