Skip to main content

How to make a graph in Excel

Microsoft Office Excel Laptop Meeting

Once you’ve wrapped your head around how to manage your data in Excel, you’ll probably find that you want to use it to enhance your presentations. Graphs are a powerful way to flex your creativity while showing off your information. Here are a few tips on how to make a graph in Excel.

The process of creating charts and graphs in Excel isn’t actually too tricky, but when you open the customization menus it can be easy to feel lost. We’ll start below by assuming that you already have all of your data on your sheet.

How to make a graph in Excel

1. Choose the right type of graph for your data. Excel offers nine different options including bar graphs, line graphs, pie graphs, and more. However, not every graph is right for every type of data.

excel graph 1

2. Highlight your data and insert your graph. This is the most important step, as it determines just what will go into your graph. Like many other Excel functions, just highlight your information and make your selection in the Chart section of the Insert tab.

excel graph 2

3. Make sure your data is on the correct axis. Sometimes you’ll find that your data populates on the wrong axis. After all, Excel can’t quite read your mind. To swap the axis, right-click on your graph and choose Select Data. Now click on Switch Row/Column.

excel graph 3

4. Now it’s time to play with the design and colors. Click on the Chart Design tab and now you can choose from some preset graph designs. You can also format the legend of your graph by clicking on it.

excel graph 4

5. You can also adjust the size of your legend to make it easier to read. To do this, just click on each label or legend and head to the Home tab to adjust the size.

excel graph 5

6. Adjust the Y-axis measurement options if needed. You can click on the Y-axis and select Format Axis to change the format to percentages and even manage the number of decimal places.

7. Finally, give your graph a name. Naming your graph is one of the easiest ways to help your audience understand exactly what your graph shows. You want to make sure that it’s specific without being too long and cumbersome.

excel graph 6

Now you have a detailed, well-named, and informative graph. You’re one step closer to becoming an Excel expert.

What else should I know?

Once you master charts and graphs, you’ll be able to handle a good chunk of what many people do in Excel every day. However, just a little more training can help you to solidify your skills as a pro. Luckily for you, we’re highlighting a beginner-friendly learning kit that can do just that.

The Professional Microsoft Excel Certification Training Bundle packs 45 hours of content to help you get started. You can dig into everything from the basics of formulas and spreadsheet management all the way up to Macros and PivotTables.

professional excel courses

The eight modules in the learning kit have a total combined retail value of $1,600 but you can get started for just a fraction of the price. Tech Deals is offering access for just $39 right now.

Over 3,000 people have already signed up to sharpen their Excel skills. If you want to join them, check it out by hitting the widget below.

$39 .00
The Professional Microsoft Excel Certification Training Bundle
Save $1561 .00
Buy it Now
The Professional Microsoft Excel Certification Training Bundle Buy it Now
Save $1561 .00 $39 .00

More posts about



from Android Authority https://ift.tt/2R1o1rR
via app promotion
Labels:

Comments

Post a Comment

Popular posts from this blog

This week in Android: It’s weird phone week

We got to play with a lot of cool tech at CES 2019 , but little was cooler than the Qualcomm Snapdragon 855 . Qualcomm had a reference device  sporting the new SoC and we were able to put it through its paces , including our very own Speed Test G . The results are impressive. In other big news this week, we found out  Motorola is planning on bringing back the Razr phone , made famous in the mid 2000s. We don’t know a lot about the phone itself, but we can make some guesses  based on a patent  from August of last year. Plus, we look ahead at the future of LG and OnePlus , including a new peculiar accessory for LG . Also, we have good news and bad news about Huawei’s security. Here are your top stories for the week 4:20 – Snapdragon 855 performance and benchmarking: Speed Test G, AnTuTu & Geekbench At CES, Gary Sims previewed the  Snapdragon 855 processor in reference hardware. He had some fun with it. 21:45 – You’ll flip for the foldable Motorol...
Post a Comment
Read more

My product launch wishlist for Instagram, Twitter, Uber and more

‘Twas the night before Xmas, and all through the house, not a feature was stirring from the designer’s mouse . . . Not Twitter! Not Uber, Not Apple or Pinterest! On Facebook! On Snapchat! On Lyft or on Insta! . . . From the sidelines I ask you to flex your code’s might. Happy Xmas to all if you make these apps right. Instagram See More Like This – A button on feed posts that when tapped inserts a burst of similar posts before the timeline continues. Want to see more fashion, sunsets, selfies, food porn, pets, or Boomerangs? Instagram’s machine vision technology and metadata would gather them from people you follow and give you a dose. You shouldn’t have to work through search, hashtags, or the Explore page, nor permanently change your feed by following new accounts. Pinterest briefly had this feature (and should bring it back) but it’d work better on Insta. Web DMs  – Instagram’s messaging feature has become the defacto place for sharing memes and trash talk about peopl...
Post a Comment
Read more

First ever drone-delivered kidney is no worse for wear

Drone delivery really only seems practical for two things: take-out and organ transplants. Both are relatively light and also extremely time sensitive. Well, experiments in flying a kidney around Baltimore in a refrigerated box have yielded positive results — which also seems promising for getting your pad thai to you in good kit. The test flights were conducted by researchers at the University of Maryland there, led by surgeon Joseph Scalea. He has been frustrated in the past with the inflexibility of air delivery systems, and felt that drones represent an obvious solution to the last-mile problem. Scalea and his colleagues modified a DJI M600 drone to carry a refrigerated box payload, and also designed a wireless biosensor for monitoring the organ while in flight. After months of waiting, their study was assigned a kidney that was healthy enough for testing but not good enough for transplant. Once it landed in Baltimore, the team loaded it into the container and had it travel 14 ...
1 comment
Read more