{"id":980,"date":"2012-02-26T15:47:36","date_gmt":"2012-02-26T05:47:36","guid":{"rendered":"http:\/\/pdtraining.com.au\/blog\/?p=980"},"modified":"2014-05-29T01:54:30","modified_gmt":"2014-05-28T15:54:30","slug":"advanced-excel-2007-training-course-canberra-using-charts","status":"publish","type":"post","link":"https:\/\/pdtraining.com.au\/blog\/excel-2007-training\/advanced-excel-2007-training-course-canberra-using-charts\/","title":{"rendered":"How to Use Charts: Advanced Excel 2007 Training in Canberra, Melbourne"},"content":{"rendered":"<figure class=\"figure alignright\"><a title=\"Excel 2007 Advanced Training Course in Canberra\" href=\"\/courses\/excel-2007-advanced-training-course\" target=\"_blank\" rel=\"\/courses\/excel-2007-advanced-training-course\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-981 size-full\" title=\"MS Excel 2007 Advanced Training Course in Canberra, Melbourne\" src=\"\/blog\/wp-content\/uploads\/2012\/02\/ms_excel_2007_advanced_training_course.png\" alt=\"MS Excel 2007 Advanced Training Course from pdtraining in Canberra, Melbourne\" width=\"300\" height=\"91\" \/><\/a><figcaption>Gain mastery in MS Excel 2007<\/figcaption><\/figure>\n<p><strong>There are six major parts to an Excel 2007 chart.<\/strong><\/p>\n<p>To gain expertise in Excel 2007, consider using\u00a0<a title=\"MS Excel 2007 Advanced Training Course\" href=\"\/courses\/excel-2007-advanced-training-course\" target=\"_blank\">MS Excel 2007 Advanced Training Course<\/a> from pdtraining in Canberra, Melbourne and other cities in Australia.<\/p>\n<p>Knowing the different parts will help you understand what information you will need in your Excel 2007 data set to make the chart relevant to your audience.<\/p>\n<p><strong>Here are the major parts of a chart in Excel 2007:<\/strong><\/p>\n<ul>\n<li><strong>Horizontal Axis:<\/strong> This part of the chart is the bottom section or line of the chart.\u00a0 This is usually the category of the data for example.\u00a0 It could represent years, product, sales person, department, etc. Typically, there are no values in this area of the chart.<\/li>\n<li><strong>Vertical Axis<\/strong>: This is the part of the chart is the left side or vertical line of the chart.\u00a0 This part of the Excel 2007 chart usually contains the values as it relates to the horizontal categories.\u00a0 It could represent units, money, percentages, etc.<\/li>\n<li><strong>Legend<\/strong>: Explains what each plotted data set represents. For example, it could distinguish that each bar represents in a column chart or what each piece of the pie represent on a pie chart.<\/li>\n<li><strong>Chart Area:<\/strong> This is the area outside of the plot area.\u00a0 This area can be changed to have different colours and looks.<\/li>\n<li><strong>Plot Area<\/strong>: This area contains the data in an illustrative format like columns, pie pieces, etc.\u00a0 The plot area could contain grid lines or not.<\/li>\n<li><strong>Series<\/strong>: This is a set of similar data grouped by category.\u00a0 For example, <a title=\"Sales Training Classes\" href=\"\/courses\/sales-training\" target=\"_blank\">sales<\/a> could represent one series and cost another.<\/li>\n<li><strong>Chart Title<\/strong>: This is usually located above the graph and it usually is a summary of what the data represents like projections, or quality report.<\/li>\n<\/ul>\n<p>Now that you know the parts of a chart, let us look at how to change the chart style.<\/p>\n<p>Excel 2007 lets you change the style of your chart with a few clicks of the mouse. You can add interesting visual effects to your chart, <a title=\"Employee Engagement Training\" href=\"\/employee-engagement-training-course\" target=\"_blank\">engaging<\/a> your audience.<\/p>\n<p class=\"p1\"><span class=\"s1\"><a title=\"\/blog\/professional-development-training\/time-management-training\/learn-time-management-sydney-manage-crisis-work\/\" href=\"\/blog\/professional-development-training\/time-management-training\/learn-time-management-sydney-manage-crisis-work\/\" target=\"_blank\">Related Article&#8230;<\/a><\/span><\/p>\n<p class=\"p2\" style=\"text-align: center;\"><span class=\"s2\"><a href=\"\/pd-training-reviews\"><b>Pdtraining <\/b><\/a><\/span><span class=\"s3\"><b>delivers 1000\u2019s of professional development courses each year in Brisbane, Sydney, Parramatta, Melbourne, Adelaide, Canberra and Perth, so you can be assured your training will be delivered by a qualified and experienced trainer.<\/b><\/span><\/p>\n<p class=\"p2\" style=\"text-align: center;\"><span class=\"s3\"><b>All public\u00a0<a title=\"MS Excel 2007 Advanced Training Course\" href=\"\/courses\/excel-2007-advanced-training-course\" target=\"_blank\">MS Excel 2007 Advanced Training<\/a><\/b><b>\u00a0courses include am\/pm tea, lunch, printed courseware and a certificate of completion.\u00a0 Customised courses are available upon request so please contact pdtraining on\u00a01300 121 400 to learn more.<\/b><\/span><\/p>\n<p class=\"p2\">\n","protected":false},"excerpt":{"rendered":"<p>Knowing the different parts will help you understand what information you will need in your Excel 2007 data set to make the chart relevant to your audience.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[363],"tags":[397,1470,1469,1471,398],"views":97,"_links":{"self":[{"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/980"}],"collection":[{"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=980"}],"version-history":[{"count":6,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/980\/revisions"}],"predecessor-version":[{"id":3677,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/980\/revisions\/3677"}],"wp:attachment":[{"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}