{"id":1493,"date":"2017-07-14T22:09:17","date_gmt":"2017-07-14T22:09:17","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-compapp\/?post_type=chapter&#038;p=1493"},"modified":"2025-10-30T14:31:55","modified_gmt":"2025-10-30T14:31:55","slug":"chart-types","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/chapter\/chart-types\/","title":{"raw":"Chart Types","rendered":"Chart Types"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Modify chart type.<\/li>\r\n<\/ul>\r\n<\/div>\r\nOnce you have created a chart, or if you are given a worksheet that contains a chart, it is very easy to change the chart type.\r\n<ol>\r\n \t<li>Click on the chart you wish to change. The Design tab should appear in the ribbon area.<\/li>\r\n \t<li>Click on Change Chart Type button<\/li>\r\n<\/ol>\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235051\/charts4.png\"><img class=\"aligncenter wp-image-1081\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235051\/charts4.png\" alt=\"An excel sheet with data entered in columns A and B through row 13. To the right of column B there is a clustered graph open representing the data in cells A1 through B13. In the ribbon there is a green box with two numbers 1 and 2. The first number is green and shows where the switch row\/column button is. The second number shows how to change the chart type.\" width=\"800\" height=\"590\" \/><\/a>\r\n<ol start=\"3\">\r\n \t<li>Click on the type of chart you would like.<\/li>\r\n<\/ol>\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235140\/charts5.png\"><img class=\"aligncenter wp-image-1082\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235140\/charts5.png\" alt=\"A change chart type dialog box is open with a line chart selected.\" width=\"600\" height=\"556\" \/><\/a>\r\n\r\nFrom this same window, you can also switch the data that is being charted. For example, you can switch which data from a row to a column or change which data is arranged on the x- or y-axis.\r\n\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235247\/charts6.png\"><img class=\"aligncenter wp-image-1083\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235247\/charts6.png\" alt=\"An excel sheet with data entered in columns A and B through row 13. To the right of column B there is a clustered graph open representing the data in cells A1 through B13. A green arrow is pointing to a green box which is showing options on how to adjust the chart.\" width=\"800\" height=\"596\" \/><\/a>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/f9648cc6-5956-435c-a79c-187b3bc82991\r\n\r\nhttps:\/\/assess.lumenlearning.com\/practice\/b95c87c9-038f-434c-8b7c-d939c07cb14e\r\n\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Modify chart type.<\/li>\n<\/ul>\n<\/div>\n<p>Once you have created a chart, or if you are given a worksheet that contains a chart, it is very easy to change the chart type.<\/p>\n<ol>\n<li>Click on the chart you wish to change. The Design tab should appear in the ribbon area.<\/li>\n<li>Click on Change Chart Type button<\/li>\n<\/ol>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235051\/charts4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1081\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235051\/charts4.png\" alt=\"An excel sheet with data entered in columns A and B through row 13. To the right of column B there is a clustered graph open representing the data in cells A1 through B13. In the ribbon there is a green box with two numbers 1 and 2. The first number is green and shows where the switch row\/column button is. The second number shows how to change the chart type.\" width=\"800\" height=\"590\" \/><\/a><\/p>\n<ol start=\"3\">\n<li>Click on the type of chart you would like.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235140\/charts5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1082\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235140\/charts5.png\" alt=\"A change chart type dialog box is open with a line chart selected.\" width=\"600\" height=\"556\" \/><\/a><\/p>\n<p>From this same window, you can also switch the data that is being charted. For example, you can switch which data from a row to a column or change which data is arranged on the x- or y-axis.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235247\/charts6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1083\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29235247\/charts6.png\" alt=\"An excel sheet with data entered in columns A and B through row 13. To the right of column B there is a clustered graph open representing the data in cells A1 through B13. A green arrow is pointing to a green box which is showing options on how to adjust the chart.\" width=\"800\" height=\"596\" \/><\/a><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_f9648cc6-5956-435c-a79c-187b3bc82991\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/f9648cc6-5956-435c-a79c-187b3bc82991?iframe_resize_id=assessment_practice_id_f9648cc6-5956-435c-a79c-187b3bc82991\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<p>\t<iframe id=\"assessment_practice_b95c87c9-038f-434c-8b7c-d939c07cb14e\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/b95c87c9-038f-434c-8b7c-d939c07cb14e?iframe_resize_id=assessment_practice_id_b95c87c9-038f-434c-8b7c-d939c07cb14e\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-1493\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Chart Types. <strong>Authored by<\/strong>: Shelli Carter. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":20,"menu_order":17,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Chart Types\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"71e32b74-93e1-46c9-a86a-18ac9ec51654, e488858f-88b3-4955-9576-8cacf701d403","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-1493","chapter","type-chapter","status-publish","hentry"],"part":1049,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/1493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/users\/20"}],"version-history":[{"count":15,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/1493\/revisions"}],"predecessor-version":[{"id":5463,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/1493\/revisions\/5463"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/parts\/1049"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/1493\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/media?parent=1493"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapter-type?post=1493"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/contributor?post=1493"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/license?post=1493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}