How to Make a Work Vs. Time Graph on Excel

Save

Microsoft Excel is a multipurpose spreadsheet program that gives users numerous options when it comes to organizing information. One of the convenient and practical methods for displaying data in Excel is in graphs. Graphs can easily be inserted into any Excel spreadsheet and, if done correctly, will automatically incorporate the data from specific cells into it. You can easily keep track of your work schedule and time spent working in an Excel graph.

  • Click and drag to select all of the cells containing your work and time data, open the "Insert" tab, and then click the "Create Chart" button and double-click on the desired type of chart from the list. The graph will now appear onscreen if you are using one of the latest versions of Excel (2007 or 2010). If you are using an earlier version of Excel, follow the onscreen prompts to finish formatting the graph.

  • Right-click on the graph, choose "Select Data" from the context menu, click on one of the "Legend Entries," such as "Series1" or "Series2," click "Edit," and then type the desired name (for example, "Work") into the "Series name" box and click "OK."

  • Change the graph type by right-clicking on the graph and selecting "Change Chart Type." To move the graph to a new Excel sheet, right-click on the graph, select "Move Chart," and then click "New sheet."

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!