Discover how you can learn and master the Microsoft Office programs, step-by-step...and get your free no obligation ebooks: "First Look Office 2007 System" and “The Keyboard Magic! ”. Yours free for visiting http://www.msoffice-tutorial-training.com
If you working on Microsoft Excel, then you simply cannot afford to leave this article without finding out how you can use the Excel charting feature to its maximum.
1. Amongst other goals, charts should tell stories. Charts should tell visual stories that describe patterns and trends in the data.
2. Good charting should give the viewer the greatest number of ideas in the shortest time with the least ink in the smallest space.
3. The purpose of formatting a chart is to make the chart easier for the viewer to understand. Too little formatting can leave a chart ambiguous.
4. Charting and graphing can take large sets of data and help to uncover patterns, trends, or to reveal relationships between data sets; this in turn can help to make business decisions.
5. Embedded Charts (on top of a sheet) are useful when you have a dynamic data set and want to see the chart change as the data changes and Chart Sheets are useful when you are printing or want to use the chart for a presentation.
6. Bar charts compare values across categories in a horizontal orientation. Values are indicated by the length of the bars. Column charts compare values across categories in a vertical orientation. Values are indicated by the length of the columns. Bar charts tend to emphasize differences better then a Column chart.
7. If you want to emphasize a trend in data points over time it is best to use a Line chart; whereas if you want to emphasize the difference between data points it is better to use a Column or Bar chart.
8. The XY (Scatter) chart plots numeric values on both the X- and Y-axes based on the value of the data (whereas a line chart plots numeric values on one axis and category labels equidistantly on the other axis).
9. A Line chart should be used instead of a XY (Scatter) chart when comparing sets of numerical data on just one axis. An XY (Scatter) should be used instead of a line chart when comparing sets of numerical data on two axes.
10. When making a pie chart, it is mandatory that you NOT include the total as one of the pie slices. The whole pie together is the total.
11. A pie chart with 30 slices can be cluttered and confusing. One solution is to make a Pie of Pie chart.
12. 3-D Pie charts are misleading because they distort the pie proportions.
13. Stacked Area and Line charts can be misleading because they can give the impression that each line represents the actual values in the data series.
- Related Videos
- Related Articles
- Ask / Related Q&A
- Excellent Exceptional Excel Recovery Tool
- Excellent Exceptional Excel Recovery Tool
- 13 Secrets to Creating Chart in Excel
- Repair Excel File
- Excel, Next To The Phone It Is Your Most Important Tool
- Error While Opening Excel File That Contains Microsoft VBA Modules
- Spreadsheet Corruption When Excel Can’t Recognize its Format
- Excel File Errors due to Out-Of-Date Antivirus Software
Using Automated Data Backup Services - Simple And Necessary
By: Trevor Johnson | 07/12/2009If you haven't had a computer totally crash on you at the worst possible moment (well, really, is there ever a good time for your computer to drop dead?), then you have been in a coma since you bought your first PC.
Speed up Hard Drives with Auslogics Disk Defrag
By: Liz Cornwell | 07/12/2009It's not a secret that computers slow down with time. No matter how fast your computer was when you first got it, you will notice that it's a lot slower just after a couple of months. This can be happening because of badly fragmented disks.
Effective Field Labeling for Easy PTI Compliance According to TraceGains
By: Thomas Cutler | 07/12/2009Effective Field Labeling for Easy PTI Compliance According to TraceGains
QC Software’s Warehouse Control System Part of Six Sigma 2010 Solutions
By: Thomas Cutler | 07/12/2009QC Software’s Warehouse Control System Part of Six Sigma 2010 Solutions
Finding The Best Registry Cleaner For Your PC
By: Deb Vornholt | 07/12/2009With a little research, you will find that most registry cleaner applications available today will only scan the surface of the registry. When this happens, the cleaner has to undergo a complete scan of each file in order to make any necessary repairs.
Tips on Safe Password
By: Margaret Atwood | 07/12/2009With so many online accounts to cope, the majority group be inclined to employment the same password in support of everything. Many plus be inclined to employment a very “easy to guess” password. These are two collective “password mistakes” with the purpose of cyber-thieves are looking in support of. One of the majority weighty things you can figure out to stay safe online is to ensure your passwords stay not public.
More Than Just CRM
By: Manny de Sousa | 07/12/2009Normally, if a business is struggling, we always put the blame more on something than on someone. So if you are running a CRM solution, whether it is hosted or in-house, you would probably say that the system is not working out well for you. Then you start to regret the high cost of investment you made and think that perhaps you are better off with another kind of contact management solution or if it is a lot safer to stick with spreadsheets.
CRM: More than Opportunity Management, and Sales Reporting
By: Manny de Sousa | 07/12/2009Technology can only get you far. There are, in fact, far more important things that you need to focus on to ensure that you can have your business smooth-sailing. One of these is to establish better and more effective sales management.
Office 2007 Tutorial - The 10 New Office 2007 Screen Elements That You Must Know
By: Wong Hing | 21/04/2009 | E-LearningHere are the ten common Office 2007 screen elements that you needs to know as you start using the Office 2007 applications.
Word 2003 Tutorial – The 8 Simple Tips to Help You Work Better with Microsoft Word
By: Wong Hing | 21/04/2009 | E-LearningYou can use these 8 useful tips that normal Word users may ignored or even don’t know how to use it? Those tricks can be really simple to apply if you read this article.
Excel 2007 Tutorial – The 8 Critical Tricks When Working with Excel Formula and Functions
By: Wong Hing | 18/04/2009 | E-LearningDo you know these 8 mistakes that most Excel users ignored when working with Excel formula? Those mistakes can be avoided if you read this article.
Excel 2007 Tutorial – 5 Simple Tips to Help You Boost Your Productivity on Using Excel Program
By: Wong Hing | 18/04/2009 | E-LearningDo you know how to increase your productivity on using Microsoft Excel program? You will when you read and take actions on this article.
Office 2007 Tutorial - 10 Solid Advantages To Upgrade To Office 2007
By: Wong Hing | 18/04/2009 | E-LearningDo you know the clear advantages when you upgrade from earlier versions of Office to Office 2007? You will when you read on this article.
13 Secrets to Creating Chart in Excel
By: Wong Hing | 06/06/2008 | SoftwareCharts depict data visually, so you can quickly spot overall trends. They're a fabulous way to help you find the meaning hidden in large amounts of data. However, what types of charts you should create is based on many situations. Here are the 13 secrets you must know when creating chart in Excel.
7-step to Delivering Presentation With Credibility
By: Wong Hing | 09/05/2007 | PresentationSeven ‘must know’ steps towards successfully delivering an effective powerpoint presentation with credibility. What you need to pay attention and what you must avoid!