Which first step should be taken when creating a chart in Excel?
Most companies (and people) don’t want to pore through pages and pages of spreadsheets when it’s so quick to turn those rows and columns into a visual chart or graph. But someone has to do it…and that person must be you. Show
Ready to turn your boring Excel spreadsheet into something a little more interesting? In Excel, you’ve got everything you need at your fingertips. Excel users can leverage the power of visuals without any additional extensions. You can create a graph or chart right inside Excel rather than exporting it into some other tool. What is the difference between Charts and Graphs?According to reference.com…“The difference between graphs and charts is mainly in the way the data is compiled and the way it is represented. Graphs are usually focused on raw data and showing the trends and changes in that data over time. Charts are best used when data can be categorized or averaged to create more simplistic and easily consumed figures.“ So technically, charts and graphs mean separate things, but in the real world, you’ll hear the terms used interchangeably. People generally accept both so don’t worry too much about it! In this post, you’ll learn exactly how to create a graph in Excel and improve your visuals and reporting…but first let’s talk about charts. Understanding exactly how charts play out in Excel will help with understanding graphs in Excel. Charts in ExcelCharts are usually considered more aesthetically pleasing than graphs. Something like a pie chart is used to convey to readers the relative share of a particular segment of the data set with respect to other segments that are available. If instead of the changes in hours worked and annual leaves over 5 years, you want to present the percentage contributions of the different types of tasks that make up a 40 hour work week for employees in your organization then you can definitely insert a pie chart into your spreadsheet for the desired impact. An example of an Excel chart.Graphs in ExcelGraphs represent variations in values of data points over a given duration of time. They are simpler than charts because you are dealing with different data parameters. Comparing and contrasting segments of the same set against one another is more difficult. So if you are trying to see how the number of hours worked per week and the frequency of annual leaves for employees in your company has fluctuated over the past 5 years, you can create a simple line graph and track the spikes and dips to get a fair idea. An example of a graph in Excel.Types of Graphs Available in ExcelExcel offers three varieties of graphs:
How to Make a Graph in Excel1. Fill the Excel Sheet with Your Data & Assign the Right Data TypesThe first step is to actually populate an Excel spreadsheet with the data that you need. If you have imported this data from a different software, then it’s probably been compiled in a .csv (comma separated values) formatted document. If this is the case, use an online CSV to Excel converter like the one here to generate the Excel file or open it in Excel and save the file with an Excel extension. After converting the file, you still may need to clean up the rows and the columns. It is better to work with a clean spreadsheet so that the Excel graph you’re creating is clean and easy to modify or change. If that doesn’t work, you may also need to manually enter the data into the spreadsheet or copy and paste it over before creating the Excel graph. Excel has two components to its spreadsheets:
After all the data values have been set and accounted for, make sure that you visit the Number section under the Home tab and assign the right data type to the various columns. If you do not do this, chances are your graphs will not show up right.
Choose the Type of Excel Graph You Want to CreateThis will depend on the type of data you have and the number of different parameters you will be tracking simultaneously. If you are looking to take note of trends over time then Line graphs are your best bet. This is what we will be using for the purpose of the tutorial. Highlight The Data Sets That You Want To UseFor a graph to be created, you need to select the different data parameters. To do this, bring your cursor over the cell marked A. You will see it transform into a tiny arrow pointing downwards. When this happens, click on the cell A and the entire column will be selected. Repeat the process with columns B and C, pressing the Ctrl (Control) button on Windows or using the Command key with Mac users. Your final selection should look something like this: Create the Basic Excel GraphWith the columns selected, visit the Insert tab and choose the option 2D Line Graph. You will immediately see a graph appear below your data values. Sometimes if you do not assign the right data type to your columns in the first step, the graph may not show in a way that you want it to. For example, Excel may plot the parameter Average Number of Leaves/Employee/Year along the X axis instead of the Year. In this case, you can use the option Switch Row/Column under the Design tab of Chart Tools to play around with various combinations of X axis and Y axis parameters till you hit on the perfect rendition. Improve Your Excel Graph with the Chart ToolsTo change colors or to change the design of your graph, go to Chart Tools in the Excel header. You can select from the design, layout and format. Each will change up the look and feel of your Excel graph. Design: Design allows you to move your graph and re-position it. It gives you the freedom to change the chart type. You can even experiment with different chart layouts. This may conform more to your brand guidelines, your personal style, or your manager’s preference. Layout: This allows you to change the title of the axis, the title of your chart and the position of the legend. You might go with vertical text along the Y axis and horizontal text along the X axis. You can even adjust the grid lines. You have every formatting tool conceivable at your fingertips to improve the look and feel of your graph. Format: The Format tab allows you to add a border in your chosen width and color around the graph to properly separate it from the data points that are filled in the rows and columns. And there you have it. An accurate visual representation of the data that you have imported or entered manually to help your team members and stakeholders better engage with the information and utilize it to create strategies or be more aware of all the constraints while taking decisions! Challenges with Making a Graph In ExcelWhen manipulating simple data sets, you can create a graph fairly easily. But when you start adding in several types of data with multiple parameters, then there will be glitches. Here are some of the challenges that you’re going to have:
You may forget to remove duplicates. This is especially true if you have imported the data from a third-party application. Generally, this type of information is not filtered of redundancies. And you might end up corrupting the integrity of your information if duplicates sneak into your pictorial representation of trends. When working with copious volumes of data, it is best to use the Remove Duplicates option on your rows. Creating graphs in Excel doesn’t have to be overly complex, but, much like with creating Gantt charts in Excel, there can be some easier tools to help you do it. If you’re trying to create graphs for workloads, budget allocations or monitoring projects, check out project management software instead. Many of those functions are automated and without manual data entry. And you won’t be left wondering about who has the latest data sets. Most project management solutions, like Workzone, have file sharing and some visualization capabilities built-in. What is the first step in creating chart?To create a chart, follow these steps: Select the data to include on the chart. Place it on its own tab. Delete the chart and try again, selecting different ranges. Change how the data is plotted by choosing Design→Data→Switch Row/Column.
What are the steps in creating a chart in Excel?Create a chart. Select the data for which you want to create a chart.. Click INSERT > Recommended Charts.. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look. ... . When you find the chart you like, click it > OK.. What's the first thing you should consider before creating a chart?7 Basic Rules for Making Charts and Graphs. Check the data. This should be obvious. ... . Explain encodings. Maybe you use a color scale to indicate magnitude or the size of a square to represent values. ... . Label axes. ... . Include units. ... . Keep your geometry in check. ... . Include your sources. ... . Consider your audience.. What is the first step in creating a chart for data in the worksheet of a spreadsheet program?How to Make a Chart in Excel. Step 1: Select Chart Type. Once your data is highlighted in the Workbook, click the Insert tab on the top banner. ... . Step 2: Create Your Chart. ... . Step 3: Add Chart Elements. ... . Step 4: Adjust Quick Layout. ... . Step 5: Change Colors. ... . Step 6: Change Style. ... . Step 7: Switch Row/Column. ... . Step 8: Select Data.. |