How to Make a Graph or Chart in Excel

Nancy Messieh 07-12-2017

If you have a data-heavy chart, it can often be helpful to have a visual representation of that data. Unsurprisingly, Excel has robust visualization features, making it easy to create powerful graphs and charts How to Create Powerful Graphs & Charts in Microsoft Excel A good graph can make the difference between getting your point across or leaving everyone dozing off. We show you how to create powerful graphs in Microsoft Excel that will engage and inform your audience. Read More in Excel. You can even use Excel to create self-updating graphs How to Create Self-Updating Microsoft Excel Charts in 3 Easy Steps Self-updating Excel charts are huge timesavers. Use these steps to add new data and watch them automatically show up in a chart. Read More !


If you want to play around with it but don’t have any data to get started, you can always use sample data available from

Once your data is entered into Excel, you can create a chart using all of the data available by selecting it all with the keyboard shortcut Ctrl + A. You can also create a chart using just a selection of the data by selecting the cells containing those numbers.

How to Create a Graph or Chart in Excel

  • Once you’ve selected the cells containing the data you want to use, go to the Insert tab and you should see a Charts section. You now have two options:
    1. Click on Recommended Charts to get an idea of what Excel thinks is best for the kind of data you’ve compiled.
    2. Or click on the specific type of chart you want to use: column/bar chart, pie chart, line graph, hierarchy chart, scatter chart, and more. (See our guide on picking the right chart for your data 8 Types of Excel Charts and Graphs and When to Use Them Graphics are easier to grasp than text and numbers. Charts are a great way to visualize numbers. We show you how to create charts in Microsoft Excel and when to best use what kind. Read More .)How to Make a Graph or Chart in Excel Excel Charts Options e1512422629285
  • Click on the type of chart you want to use and Excel will instantly transform your data into a visual representation.
  • You can now customize the chart to appear the way you want:
    1. Click the Plus button to determine which of these elements will appear on your chart: Chart title, Data labels (i.e. the actual numbers in your Excel chart), axis titles, gridlines, the legend, and more, depending on the type of chart you’ve chosen.
    2. Click the Style button (paintbrush) to select the style and color of your chart. In the Style tab, you can choose from pre-set themes that make changes to your chart’s overall appearance. In the color tab, you can choose from existing color schemes.
    3. Click the Filter button to selectively choose which values, or which pieces of data, will appear in your chart.
  • Excel charts are “live” elements. This means that if you make a change to the selected data, the changes will be instantly visible in the chart.
  • If you right click the chart, you can change to a different graph or chart type, add data call outs, and more.

You can also copy and paste your chart into other Microsoft products like Word, or into design programs like Adobe Photoshop, if you want to make a more elaborately designed chart.

What kinds of charts do you create with Excel? Is there another program you prefer to use for graphs or charts? Let us know in the comments. 

Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.

Whatsapp Pinterest

Leave a Reply

Your email address will not be published. Required fields are marked *