How to make a graph in excel

How to Make a Graph in Excel (2024 Tutorial)

Start using ClickUp today

  • Manage all your work in one place
  • Collaborate with your team
  • Use ClickUp for FREE—forever

Over the past years, one of the things we’ve learned is that Microsoft Excel is like a Hallmark movie. 

Some of us can’t get enough of them and others just can’t stand it. 💔😬

Regardless of your preference, if you’re a manager or business owner, you’ll probably have to rely on Excel for business insights. 

Tools like Microsoft Excel graphs are helpful for data analysis and tracking.
And wayyy better than endless spreadsheets that can easily trigger a migraine. 

Then why not turn your boring Excel spreadsheet into something interesting?

In this article, we’ll learn what an Excel graph is, how to make a graph in Excel, and its drawbacks. We’ll also suggest an alternative to create effortless graphs.

Let’s graph away!

Summarize this article with AI ClickUp Brain not only saves you precious time by instantly summarizing articles, it also leverages AI to connect your tasks, docs, people, and more, streamlining your workflow like never before.
ClickUp Brain
Avatar of person using AI Summarize this article for me please

What are Graphs & Charts in Microsoft Excel?

Graphs in Excel are graphical representations of variations in values of data points over a given period. 

In other words, it’s a diagram that represents changes in comparison to one or more variables.

Too technical? 👀

Take a look at the image for clarity:

Bar Chart in Excel

Wondering if graphs and charts in Excel are the same?

Graphs are mostly numerical representations of data as it shows how one variable is affecting or changing another.

On the other hand, charts are visual representations where variables may or may not be associated. They’re also considered more aesthetically pleasing than graphs. For example, a pie chart. 🥧

However, if you’re wondering how to make a chart in Excel, it isn’t very different from making a graph.

But for now, let’s focus on the main plot: graphs!✨

Summarize this article with AI ClickUp Brain not only saves you precious time by instantly summarizing articles, it also leverages AI to connect your tasks, docs, people, and more, streamlining your workflow like never before.
ClickUp Brain
Avatar of person using AI Summarize this article for me please

Steps To Make a Graph in Excel

The first (and obvious step) is to open a new Excel file or a blank Excel worksheet.

Done?

Then let’s learn how to create a graph in Excel.

⭐️ Step 1: fill the Excel sheet with data

Start by populating your Excel spreadsheet with the data you need.

You may import this data from different software, insert it manually, or copy and paste it.

For our example, let’s say you’re an owner of a movie theater in a small town, and you often screen older movies. You probably want to track the sales of your tickets to see which movie is a hit so you can screen it frequently.

Let’s do that by comparing the ticket sales in January and February.

Here’s what your data might look like:

Spreadsheet in Excel

Column A contains the movie names.

Column B contains tickets sold in January.

And column C contains tickets sold in February.

You can bold headings and center align your text for better readability.

Done? Okay, get ready to pick a graph.

⭐️ Step 2: determine the Excel graph type you want

The type of graph you pick will depend on the data you have and the number of different parameters you want to track.

You’ll find the different graph types under the Excel Insert tab, in the Excel Ribbon, arranged close to one another like this:

Insert tab toolbar in Excel

Note: The Excel Ribbon is where you can find the Home, Insert, and Draw tabs.

Here are some of the different Excel graph or chart type options you can choose from:

  • Line graph
  • Column graph or bar graph
  • Pie graph or chart
  • Combo chart
  • Area chart
  • Scatter plot chart

➡️  Fun fact: Excel can help you decide the graph or chart type with the Recommended Charts (formerly known as Chart Wizard) option. 

If you want to take notes of trends (increase or decrease) over time, then a line graph is perfect.

But for a long time frame and more data, a bar graph is the best option.

We’ll use these two graphs for the purpose of this Excel tutorial.

Summarize this article with AI ClickUp Brain not only saves you precious time by instantly summarizing articles, it also leverages AI to connect your tasks, docs, people, and more, streamlining your workflow like never before.
ClickUp Brain
Avatar of person using AI Summarize this article for me please

How To Create a Line Graph in Excel – 3 Steps

A line graph in Excel typically has two axes (horizontal and vertical) to function. 

You need to enter the data in two columns.

Lucky for us, we’ve already done this when creating the ticket sales data table.

⭐️ Step 1: select data to turn into a line graph

Click and drag from the top-left cell (A1) in your ticket sales data to the bottom-right cell (C7) to select. Don’t forget to include column headers.

This will highlight all the data you want to display in your line graph.

Selecting data in Excel spreadsheet

⭐️ Step 2: insert line graph

Now that you’ve selected your data, it’s time to add the line graph.

Look for the line graph icon under the Insert tab.

Graph icon in Excel

With the data selected, go to Insert > Line. Click on the icon, and a dropdown menu will appear to select the type of line chart you want. 

For this example, we’ll choose the fourth 2-D line graph (Line with Markers).

Excel will add your line graph representing your selected data series.

Presenting data as a line graph in Excel

You’ll then notice the names of the movies appear on the horizontal axis and the number of tickets sold on the vertical axis. 

⭐️ Step 3: customize your line graph

After adding the line graph, you’ll notice a new tab called Chart Design on your Excel Ribbon. 

Select the Design tab to make the line graph your own by choosing the chart style you prefer.

Change the design of your line chart in Excel

You can also change the graph’s title.

Select the Chart Title > double click to name > type in the name you wish to call it. To save it, simply click anywhere outside the graph’s title box or chart area.

We’ll name our graph “Movie Ticket Sales.” 

Renaming your line graph in Excel

Anything else you need to tweak?

If you spot anything, now is the time to make those edits! 

For example, here you can see The Godfather and Modern Times are smooshed together.

Let’s give them some space.

How?

Just drag any corner of the graph until it’s how you desire. 

Resize your line graph in Excel

These are just some examples. You can customize every chart element if you like including the Axis Labels (the color of the lines that represent each data point, etc.)

Just double click on any chart element to open a sidebar for formatting like this:

Change the color of the lines in your graph in Excel

That’s it! You’ve successfully created a line graph in Excel!

Now, let’s learn how to make a bar graph. 📊

Summarize this article with AI ClickUp Brain not only saves you precious time by instantly summarizing articles, it also leverages AI to connect your tasks, docs, people, and more, streamlining your workflow like never before.
ClickUp Brain
Avatar of person using AI Summarize this article for me please

3 Steps To Create a Bar Graph in Excel

Any Excel graph or Excel chart begins with a populated sheet. 

We’ve already done this, so copy and paste the movie ticket sales data to a new sheet tab in the same Excel workbook.

⭐️ Step 1: select data to turn into a bar graph

Like step 1 for the line graph, you need to select the data you wish to turn into a bar graph.

Drag from cell A1 to C7 to highlight the data.

Selecting data in Excel spreadsheet

⭐️ Step 2: insert bar graph

Highlight your data, go to the Insert tab, and click on the Column chart or graph icon. A dropdown menu should appear.

Select Clustered Bar under the 2-D bar options. 

Note: you can choose a different type of bar chart option like a 3D clustered column or 2D stacked bar, etc.

As soon as you click on the bar graph option, it’ll be added to your Excel sheet.

Present data as bar graph in Excel spreadsheet

⭐️ Step 3: customize your Excel bar graph

Now, you can go to the Chart Design tab in the Excel Ribbon to personalize it.

Click on the Design tab to apply a bar style you prefer from the many options. 

Change the design of your bar graph in Excel

You know the next step! Change the bar graph’s title.

Select the Excel Chart Title > double click on the title box > type in “Movie Ticket Sales.”

Then click anywhere on the excel sheet to save it.

Rename your bar graph in Excel

Note: you can also add other graph elements such as Axis Title, Data Label, Data Table, etc., with the Add Chart Element option. You’ll find it under the Chart Design tab.

And that’s a wrap. 🎬 

You’ve successfully created a bar graph in Excel!

Well, that was fun. 

But the question is, do you have the time for graphs in your busy work schedule?

And that’s just the teaser when it comes to Excel graph drawbacks.

Read on to watch the full movie. 👀

Bonus: Check out these Excel Alternatives!

Summarize this article with AI ClickUp Brain not only saves you precious time by instantly summarizing articles, it also leverages AI to connect your tasks, docs, people, and more, streamlining your workflow like never before.
ClickUp Brain
Avatar of person using AI Summarize this article for me please

Excel Graph Alternatives

Whether you’re tracking time, monitoring projects, overseeing personnel, or measuring ticket sales, ClickUp delivers with just a few clicks, steering clear of the setbacks that come with Excel.

The limitations of Excel can make it time-consuming, complex, costly, and prone to errors. Fortunately, ClickUp is designed to keep this to a minimum. It’s a more automated system, ensuring that time-consuming manual data entry becomes a thing of the past. Use the features below to get started with ClickUp!

Graph Templates

ClickUp Bar Graph Whiteboard Template

ClickUp’s Bar Graph Whiteboard Template enables you to transform your raw data into a visually appealing bar graph, providing a clear and concise overview of your data at a glance. Now, you can easily compare different data sets, measure progress, or track changes over specific periods – all within a neat, easy-to-understand bar graph. Perfect for presentations or simply gaining a better understanding of your data, the Bar Graph Whiteboard is just another way ClickUp is simplifying your data management and representation.

Line Chart Widgets

The Line Chart Widget is a Custom Widget on our Dashboard. Use this ClickUp production to visualize literally anything in the form of a line graph.

It can be tracking profits, total daily sales, or how many movies you’ve watched in a month. 

Like we said, a-n-y-t-h-i-n-g!

Line Chart Widget in ClickUp Dashboards

Visualize any set of values as a line graph with the Line Chart Widget on ClickUp’s Dashboard!

And that’s not it. You can visualize your data in many different ways too.

Just use any of these Custom Widgets:

  • Calculations
  • Bar charts
  • Battery chart
  • Pie chart
  • And more
Pie Chart Custom Widget in ClickUp

Present your data visually as a pie chart with Custome Widgets in ClickUp!

Gantt Chart view

Just like it’s difficult to love just one movie genre, we totally get that graphs alone don’t work.

And that’s why we have charts too!

Specifically, ClickUp’s Gantt chart, an interactive chart with live updates and progress tracking that can help you:

Gantt view in ClickUp

Drawing a relationship from one task to a future task in ClickUp’s Gantt Chart view!

Table view

If you’re a fan of the Excel grids, ClickUp has your back.

Starring… ClickUp Table view

This view lets you visualize your tasks in the spreadsheet style.

It’s super fast and allows easy navigation between fields, bulk edits, and data export.

➡️ Fun fact: you can quickly copy and paste your table’s data into other programs, like MS Excel. Just click and drag to highlight the cells you want to copy.

Copy and paste data from ClickUp into other programs

Highlight data from your table in ClickUp to copy and paste into other programs!

And that was just the trailer for you. 📽️

Here are some more powerful ClickUp features in store for:

Summarize this article with AI ClickUp Brain not only saves you precious time by instantly summarizing articles, it also leverages AI to connect your tasks, docs, people, and more, streamlining your workflow like never before.
ClickUp Brain
Avatar of person using AI Summarize this article for me please

Moving Beyond Excel for Graphs and Data Visualization

Graphs and charts offer us an intuitive, pleasing, and quick way to interpret complex data sets. While Microsoft Excel is the go-to for many of us when creating graphs, it also has certain limitations and complexities. The good news is that there are alternative tools out there – promising in functionality, efficiency, and ease of use.

ClickUp is one such user-friendly tool that allows you to create clean and customized graphs effortlessly while also ensuring data accuracy. Features like Gantt Chart view, Table view, and templates make your data management process much more straightforward.

With ClickUp, busy business owners, managers, and all professionals alike can enjoy easy graph-making and data representation, without needing an Excel crash-course. It’s all about making your workload lesser and your success graphs steeper! So, forget your graph woes and start your free trial with ClickUp today!

Related readings:

Questions? Comments? Visit our Help Center for support.

Sign up for FREE and start using ClickUp in seconds!
Please enter valid email address