how to plot a graph in excel using a function

Let us assume that we are tracking Average Number of Hours Worked/Week/Employee and Average Number of Leaves/Employee/Year against a five year time span. This is what we will be using for the purpose of the tutorial. If you are looking to take note of trends over time then Line graphs are your best bet. This will depend on the type of data you have and the number of different parameters you will be tracking simultaneously. Choose the Type of Excel Graph You Want to Create If you do not do this, chances are your graphs will not show up right.įor example if column B is measuring time, ensure that you choose the option Time from the drop down menu and assign it to B. The columns that are vertical and marked with alphabetsĪfter 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.The rows that are horizontal and marked with numbers.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.Įxcel has two components to its spreadsheets: 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 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.Īfter converting the file, you still may need to clean up the rows and the columns. csv (comma separated values) formatted document. If you have imported this data from a different software, then it’s probably been compiled in a. The first step is to actually populate an Excel spreadsheet with the data that you need. Fill the Excel Sheet with Your Data & Assign the Right Data Types People generally accept both so don’t worry too much about it! So technically, charts and graphs mean separate things, but in the real world, you’ll hear the terms used interchangeably. Charts are best used when data can be categorized or averaged to create more simplistic and easily consumed figures.“ Graphs are usually focused on raw data and showing the trends and changes in that data over time. What is the difference between Charts and Graphs?Īccording to … “The difference between graphs and charts is mainly in the way the data is compiled and the way it is represented. You can create a graph or chart right inside Excel rather than exporting it into some other tool. Excel users can leverage the power of visuals without any additional extensions. In Excel, you’ve got everything you need at your fingertips. Ready to turn your boring Excel spreadsheet into something a little more interesting? But someone has to do it…and that person must be you. 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.

How to plot a graph in excel using a function