How to Make a Graph in Microsoft Excel

Graphs and charts are useful tools in Microsoft Excel. Knowing how to make a graph in Excel is essential for anyone who works with numbers. Here, we’ll go over the process of creating a graph.

Start by selecting the data you want to include. Then, choose from the different graph types like bar graphs, line graphs, and pie charts. These types have advantages depending on your analysis.

Customize your graph by adjusting titles, axes labels, data series colors, and more. This way, you can make graphs that look good and show your message.

Excel also has features and tools to help you with your graphs. You can add trendlines, error bars, or even combine multiple graph types.

Learning how to make a graph in Excel is an important skill. Excel makes it easy to create professional-looking graphs for any project.

The idea of visualizing data through graphs dates back centuries. William Playfair first introduced various graphical forms in his book “The Commercial and Political Atlas” in 1786. Since then, manual and computer methods have improved, making it easier to represent data visually.

Overview of Microsoft Excel Graphing Tools

Harness the power of Microsoft Excel for creating visually-appealing and informative graphs. Choose from an array of options – from simple bar charts to complex scatter plots. Plus, get access to advanced tools such as histograms and waterfall charts.

Customize with colors, fonts, and styles to match your needs. Label, add legends, titles, and axis labels for enhanced clarity.

Take advantage of the dynamic graphing feature. Automatically update graphs when data changes – no need to recreate them!

Unlock new ways to captivate your audience. Transform raw numbers into engaging visualizations with Microsoft Excel’s graphing capabilities. Bring data to life!

Step 1: Open Microsoft Excel and Create a New Worksheet

Microsoft Excel is a great tool for data organization and analysis. A key feature of the program is the capability of creating charts and graphs. This guide will help you with the initial step of this process: opening the program and creating a new worksheet.

To begin, open Microsoft Excel. This can be done from your desktop or list of programs. Once open, you will see a blank worksheet.

Go to the top left corner of the screen, and click “File” to open the file menu. Select “New” to create a new workbook. A dialogue box will appear where you can select various templates or “Blank Workbook”.

After choosing “Blank Workbook”, a new worksheet will appear. This is where you will enter and organize data, as well as create the graph. Feel free to customize the appearance of the worksheet by altering column widths, adding borders, or applying different formatting options.

Now you have opened Microsoft Excel and created a new worksheet. Future guides will explain how to input data, select chart types, customize axis labels, and more.

It’s interesting to note that Microsoft Excel was first released in 1985 as part of Microsoft Office. It has since become a vital tool for various businesses and individuals due to its versatility and wide range of functionalities.

Step 2: Enter Data for the Graph

Experience the ease of entering data for a graph, thanks to Microsoft Excel! With this program, you can quickly and easily input relevant information to create meaningful visuals. Here’s what to do:

  1. Open a new workbook.
  2. Find the cells where you want to enter your data.
  3. Insert the data into the cells. E.g. month names in one column and sales figures in another for a line graph.
  4. Put each category or variable in its own row or column.
  5. Check the data for accuracy.
  6. Save the workbook regularly.

When entering data for a graph, it’s key to consider thoroughness, consistency, and relevance. Making sure all vital variables and categories are included ensures more insightful graphs. Also, keeping the data consistent in its organization helps with analysis and interpretation.

Follow these steps and principles when using Microsoft Excel to generate meaningful graphs. You’ll get visually pleasing representations that’ll give you valuable insights into the dataset.

Step 3: Select the Data to be Included in the Graph

Creating a graph in Microsoft Excel? Selecting the data is essential. To do this:

  1. Open the data spreadsheet.
  2. Highlight the cells you want in the graph.
  3. Include the x and y axis values.
  4. Hold Ctrl to select multiple sets of data.
  5. Release the mouse button when done.

Remember: Select only the relevant data. Unneeded data can lead to misinterpretation.

Pro Tip: Use keyboard shortcuts to quickly select data. Shift+arrows or Ctrl+Shift+arrows.

Step 4: Choose the Type of Graph/Chart

Selecting the right type of graph or chart in Microsoft Excel is essential for effective data presentation. Different types of graphs and charts can present data in various ways. Consider the data’s characteristics, your objectives, and the available options to choose the most suitable type. After selecting, customize the graph or chart with colors, labels, and titles.

For example, a business analyst needed to show sales trends over time. He considered the data and his objectives, then looked at the options. He chose a line graph that displayed the increasing trend of sales in a clear way. By customizing it, he successfully grabbed the attention of his audience and communicated the desired information.

Step 5: Customize the Graph

Personalize your graph in Microsoft Excel with these five steps! Follow the steps below to make your graphs shine:

  1. Experiment with chart styles
  2. Modify axis labels
  3. Adjust colors and fonts
  4. Add extra elements
  5. Explore formatting options

Spice it up with unique details that suit your audience. For example, a marketing team impressed their clients by customizing their graphs with vibrant colors and clear annotations. So go ahead, make your graphs shine!

Step 6: Adjusting Data Range and Updating the Graph

It’s important to adjust the data range and update graphs in Microsoft Excel. Here’s how you can do it:

  1. Select your graph by clicking on it. Notice that the data range is highlighted.
  2. To include/exclude data, click and drag the handles of the range. Or type a new range manually.
  3. Click on the “Select Data” option from the “Design” tab. This opens a dialog box where you can make changes to the data range and series.
  4. Once done, click “OK” to update the graph. Your adjustments will be seen immediately.

By adjusting the data range, you can present accurate info in an appealing way. Feel free to experiment with different data ranges and series. Revisit and update your graphs as new info becomes available. Get creative and make your visualizations shine!

Step 7: Exporting or Sharing the Graph

Saving your Excel file is a must before exporting or sharing a graph. Click the graph you want, right-click and choose ‘Copy’. Open the application you want to export/share into, right-click and select ‘Paste’. Adjust formatting if necessary. Then save or send!


  • Include a description/caption to explain its significance.
  • Choose the right file format, and make it accessible to all.
  • This will help you professionally share your Microsoft Excel graph in an easy to understand way.


Microsoft Excel is an amazing tool for transforming raw data into visually appealing, informative graphs. It offers a wide range of features to make graph-making a breeze. With a few simple steps, you can easily convey complex info in a clear and concise manner.

Plus, Excel’s dynamic graphs can auto-update when data changes. So, no more manually updating graphs! It also provides plenty of customization options, so you can create impactful graphs that represent your message.

Fun Fact: Microsoft Excel was first released in 1985! Now, it’s one of the most widely used spreadsheet programs around the world.

Start your free trial now

No credit card required

Your projects are processes, Take control of them today.