Once you have thought carefully about managing your data in Excel, you will probably find that you want to use it to improve your presentations. Charts are a powerful way to increase your creativity and show your information. Here are a few tips for creating a chart in Excel.
Creating charts and diagrams in Excel isn't much of a pain, but opening the customization menus can make it easy to feel lost. We will start below with the assumption that you have all your data on your sheet.
Making a chart in Excel
1. Choose the right type of chart for your data. Excel offers nine different options, including bar charts, line charts, pie charts, and more. However, not every graph is suitable for every type of data.
2. Highlight your data and insert your chart. This is the most important step because it determines what exactly goes on your chart. As with many other Excel functions, just highlight your information and make your selection in the chart section of the Insert tab .
3. Make sure your data is on the correct axis. Sometimes you notice that your data is entered on the wrong axis. After all, Excel cannot read your thoughts completely. To switch the axis, right click on your graph and choose Select Data . Now click on Switch row / column .
4. Now it's time to play with the design and the colors. Click on the tab Chart design and now you can choose from a number of preset chart designs. You can also format the legend of your chart by clicking on it.
5. You can also adjust the size of your legend to make it easier to read. To do this, click on any label or legend and go to the Home tab to adjust the size.
6. Adjust the Y-axis measurement options if necessary. 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, name your chart. Naming your chart is one of the easiest ways to help your audience understand exactly what your chart is showing. You want to make sure it is specific without being too long and cumbersome.
Now you have a detailed, well-named and informative graph. You are one step closer to becoming an Excel expert.
What else do I need to know?
Once you master graphs and charts, you can handle a good deal of what many people do in Excel every day. . However, a little more training can help strengthen your skills as a professional. Luckily for you, we emphasize a beginner-friendly learning kit that can do just that.
The Professional Microsoft Excel Certification Training Bundle includes 45 hours of content to get you started. You can explore everything from formulas and spreadsheet management to macros and pivot tables.
The eight modules in the learning kit have a total combined retail value of $ 1,600, but you can get started for only a fraction of the price. Tech Deals currently offers access for just $ 39.
More than 3,000 people have already signed up to hone their Excel skills. If you want to join, check it out by clicking on the widget below.
$ 39 .00
The Professional Microsoft Excel Certification Training Bundle
] $ 1561 .00
Save $ 1561 .00 $ 39 . 00