HomeApplicationOffice informationInstructions for creating charts in Excel 2007 or 2010

Instructions for creating charts in Excel 2007 or 2010

TipsMake.com - The chart is a very effective way of displaying data in calculation or statistics programs, especially Microsoft Excel. In the tutorial below, we will cover the basic operations to create a chart from the data table in Excel 2007 or 2010 version.

First, we need a statistic data sheet calculated in% as shown below:

Instructions for creating charts in Excel 2007 or 2010 Picture 1

Select which pieces of information to list in the chart, you can select individual components, but remember not to select the total. Then, click the Insert> Pie button, where we will have a separate choice between 2D and 3D charts:

Instructions for creating charts in Excel 2007 or 2010 Picture 2

Shortly thereafter, the chart will display on the text. The next thing to do is to change or customize a set number to increase efficiency. Choose the chart you just created and click Chart Tools, which includes 3 main items: Design , Layout , and Format :

Instructions for creating charts in Excel 2007 or 2010 Picture 3

The corresponding functions in the Chart Tools section :

Instructions for creating charts in Excel 2007 or 2010 Picture 4

Depending on the data table and the desired presentation, please choose to set it up as you like. Of course, in the first practice, the results will not be as expected. Below is a sample of our test:

Instructions for creating charts in Excel 2007 or 2010 Picture 5

Good luck!

4 ★ | 1 Vote
instructionsdescriptionsbasictechniqueschartspie chartmicrosoft officeexcel20072010charting

You should read it

May be interested

  • Backing up data from Gmail, Google Docs is easy with BackupGooPhoto of Backing up data from Gmail, Google Docs is easy with BackupGoo
    when using google software such as gmail, google calendar or google docs, if you want to search for a software to help backup your data on these services ...
  • Explore * .docx file in Windows 7Photo of Explore * .docx file in Windows 7
    everyday, we often work with many text files, mostly word. but there is one interesting thing that still exists in * .docx format of microsoft office and open office that many people know: it's not really a single file ...
  • Share PowerPoint 2010 presentation files over the InternetPhoto of Share PowerPoint 2010 presentation files over the Internet
    in everyday work, many of us still use powerpoint to display document and text files. but do you know that there is one convenient feature in powerpoint 2010, broadcast slide show - that makes it easy for users to share this presentation to a computer, smartphone or tablet.
  • Use Pivot Table in the Google Docs SpreadsheetPhoto of Use Pivot Table in the Google Docs Spreadsheet
    this week, google docs has officially unveiled excel's pivot tables - a long-standing omission feature. this process is really useful when you have a spreadsheet with huge amounts of data, and you have to create general statistics, with a mechanism that works on rotation, retrieves information from many different angles. ..
  • Instructions to remove background images with PowerPoint 2010Photo of Instructions to remove background images with PowerPoint 2010
    in the previous articles, we presented some basic methods to remove background images in photos using adobe photoshop, but besides, you have tried to think about how to work on with powerpoint 2010 yet. ?
  • Data synchronization between platforms and devicesPhoto of Data synchronization between platforms and devices
    people now no longer have to 'stick around' with a particular storage or device when they want to finish work on a laptop, tablet or even a smartphone.

Office information