Loading
Loading
  • Home

  • Productivity

  • App tutorials

App tutorials

1 min read

How to Make a Chart or Graph in Excel Online

By Justin Pot · May 30, 2019
mark-chart-graph-excel-online primary img

Excel Online offers most of the features found in the desktop version of Excel, and that includes making charts and graphs. Here's how to make a chart or graph in Excel online.

Select the data you'd like to include in your graph, then open the Insert section of the Ribbon. You'll find an assortment of icons for making charts.

Graphs and charts toolbar in Excel Online

Click any of these icons to make the corresponding type of chart. Or, if you want more options, click the arrow in the right side of this box.

Click the arrow to find more chart and graph options

Hover your mouse over any chart type to read a description.

Hover over any chart or graph type to read more about them

Click what you want and your chart will show up right away. We’ve compiled a spreadsheet of US population data, organized by state. If we select the column with the state names along with one year’s worth of data, we can make a quick bar graph comparing the top ten U.S. states, by population:

Making a bar graph in Excel online

Here's a chart showing how U.S. population changed, by state, between 2010 and 2018:

Making a comparative bar graph in Excel Online

And here's a pie chart, which breaks the U.S. population down by state:

Making a pie chart in Excel online

You can customize your graph by selecting it and using the Chart section of the Ribbon.

Chart tools in Excel Online

For example, you can move or change the chart's name.

Change chart name in Excel Online

Or you can decide where the legend should be, or even remove it entirely.

Configure your legend in Excel Online

Fine tune everything until your chart looks exactly the way you want.

Learn more in our beginner's guide to Excel online. Or, check out our Excel integrations to learn how to connect Excel with thousands of apps.

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'