Chart

Modified on Thu, Dec 4 at 11:08 AM

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. Select a range of data you want to make a chart.
  2. Click the Chart icon_chart.png icon on the toolbox. Or click Insert-Chart.
  3. Select the chart type on the Insert Chart dialog box.
    cell_chart.png

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 icon_expand.png 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