Excel is a great program to use for making and editing spreadsheets, but it can also be used to quickly produce some professional graphs. Excel graphs aren’t extremely detailed, but they are a solid way to add easy-to-read data to any presentation or report.
Step 1- Enter information into a spreadsheet. Columns will be vertical on the graph and rows will be horizontal.
Step 2- Highlight the cells you want to graph.
Step 3- Go to Insert, then Chart.
Step 4- Choose the kind of graph you want to use. Your choice largely depends on what you’ll be using the graph for and what kind of information you have. To compare how things have changed over time, a line graph may be ideal. To display growth, a bar or column graph works nicely. Evaluate your information and how you want to present it.
Step 5- At this point, you have a basic chart. Now it’s time to spruce it up a bit. Add a title by clicking the “Chart Title” box at the top. You can change the colors using the options at the top, name each axis, and move or change the legend, which is located at the bottom. The goal is simply to make it very clear to read. A good graph is useless if it can’t be understood easily.
What do you think of our guide to making a graph in Excel? Pretty simple, right? If you have some advice not listed here, feel free to share it in the comments below.
- The True Story of the Microsoft Courier's Tragic Death
- Microsoft’s Class Action
- The Best Microsoft Word Alternatives That Are Totally Free
- Microsoft calls for regulation of facial recognition, saying it's too risky to leave to industry alone
- Competition concern over Microsoft’s decision to use Google web technology
- Microsoft’s Bing search engine shows child pornography, report claims
- Family Out $13K After Son Makes Series of In-Game Xbox Purchases
- Law Architects: New legal jobs make technology part of the career path
- Bill Gates honors Microsoft co-founder Paul Allen, who died Monday
- European Commission Approves Microsoft Acquisition of LinkedIn Subject to Conditions
- Microsoft soars past $800 billion in value after bumper results
How to make a graph in Microsoft Excel have 422 words, post on www.digitaltrends.com at February 8, 2014. This is cached page on Konitono.Blog. If you want remove this page, please contact us.