{"id":18732,"date":"2013-05-08T15:55:51","date_gmt":"2013-05-08T10:25:51","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18732"},"modified":"2024-04-12T14:24:18","modified_gmt":"2024-04-12T08:54:18","slug":"create-modify-and-position-diagrams-and-charts-based-on-worksheet-data","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/","title":{"rendered":"Create, Modify, and Position Diagrams and Charts Based on Worksheet Data"},"content":{"rendered":"<h4><strong>Create, Modify, and Position Diagrams and Charts Based on Worksheet Data<\/strong><\/h4>\n<h2>diagrams and charts<\/h2>\n<p>Both diagrams and charts are pictorial representations of information. Both are used to communicate visually, and both try to simplify the information they&#8217;re conveying. But there are some differences.<\/p>\n<p>A\u00a0diagram\u00a0is designed to:<\/p>\n<ul type=\"disc\">\n<li>Demonstrate or explain how something works.<\/li>\n<li>Clarify the relationship between the parts of a whole.<\/li>\n<\/ul>\n<p>Using a diagram is a good way to illustrate conceptual material and to enliven documents. For example, you can illustrate how the characters in a novel relate to each other.<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/1.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30677\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/1.gif\" alt=\"1\" width=\"236\" height=\"216\" \/><\/a><\/p>\n<p>A\u00a0chart\u00a0is designed to:<\/p>\n<ul type=\"disc\">\n<li>Present information in tabular or graphic format.<\/li>\n<li>Plot specific information.<\/li>\n<\/ul>\n<p>Using a chart is a great way to make complicated material\u2014such as comparisons, patterns, and trends in data\u2014easy to view and understand. For instance, rather than analyze several columns of worksheet numbers, you can use a chart to compare at a glance how the enrollment statistics of girls and boys are changing over a period of years.<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/2.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30678\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/2.gif\" alt=\"2\" width=\"211\" height=\"177\" \/><\/a><\/p>\n<h2>Creating a chart<\/h2>\n<p>You can create a chart on its own worksheet or as an embedded object on another worksheet. You can also publish a chart on a Web page. To create a chart, you must first enter the data for the chart on the Excel worksheet. Then select that data and either use the\u00a0Chart Wizard\u00a0(on the\u00a0Insert\u00a0menu, click\u00a0Insert) to choose the chart type and the various chart options, or use the\u00a0Chart\u00a0toolbar to create a basic chart that you can format later.<\/p>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/3.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30679\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/3.gif\" alt=\"3\" width=\"226\" height=\"255\" \/><\/a><\/p>\n<div class=\"apply\">\n<h3>Apply for MS Excel Certification Now!!<\/h3>\n<p><a href=\"https:\/\/www.vskills.in\/certification\/excel-online-certification-course\" target=\"_blank\" rel=\"noopener\">https:\/\/www.vskills.in\/certification\/excel-online-certification-course<\/a><\/p>\n<h4><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/certified-excel-2003-professional\/\" target=\"_blank\" rel=\"noopener\"><strong>Back to Tutorial<\/strong><\/a><\/h4>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Create, Modify, and Position Diagrams and Charts Based on Worksheet Data diagrams and charts Both diagrams and charts are pictorial representations of information. Both are used to communicate visually, and both try to simplify the information they&#8217;re conveying. But there are some differences. A\u00a0diagram\u00a0is designed to: Demonstrate or explain how something works. Clarify the relationship&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[47],"tags":[5121,5119,5120],"class_list":["post-18732","page","type-page","status-publish","hentry","category-ms-excel","tag-and-position-diagrams-and-charts-based-on-worksheet-data","tag-create","tag-modify"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create, Modify, and Position Diagrams and Charts Based on Worksheet Data - Tutorial<\/title>\n<meta name=\"description\" content=\"Create, modify, and position diagrams and charts based on worksheet data. Govt of India Certification for Excel\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create, Modify, and Position Diagrams and Charts Based on Worksheet Data - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Create, modify, and position diagrams and charts based on worksheet data. Govt of India Certification for Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:54:18+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/1.gif\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/\",\"name\":\"Create, Modify, and Position Diagrams and Charts Based on Worksheet Data - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/1.gif\",\"datePublished\":\"2013-05-08T10:25:51+00:00\",\"dateModified\":\"2024-04-12T08:54:18+00:00\",\"description\":\"Create, modify, and position diagrams and charts based on worksheet data. Govt of India Certification for Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/#primaryimage\",\"url\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/1.gif\",\"contentUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create, Modify, and Position Diagrams and Charts Based on Worksheet Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create, Modify, and Position Diagrams and Charts Based on Worksheet Data - Tutorial","description":"Create, modify, and position diagrams and charts based on worksheet data. Govt of India Certification for Excel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/","og_locale":"en_US","og_type":"article","og_title":"Create, Modify, and Position Diagrams and Charts Based on Worksheet Data - Tutorial","og_description":"Create, modify, and position diagrams and charts based on worksheet data. Govt of India Certification for Excel","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:54:18+00:00","og_image":[{"url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/1.gif","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/","name":"Create, Modify, and Position Diagrams and Charts Based on Worksheet Data - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/#primaryimage"},"thumbnailUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/1.gif","datePublished":"2013-05-08T10:25:51+00:00","dateModified":"2024-04-12T08:54:18+00:00","description":"Create, modify, and position diagrams and charts based on worksheet data. Govt of India Certification for Excel","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/#primaryimage","url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/1.gif","contentUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-modify-and-position-diagrams-and-charts-based-on-worksheet-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Create, Modify, and Position Diagrams and Charts Based on Worksheet Data"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=18732"}],"version-history":[{"count":7,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18732\/revisions"}],"predecessor-version":[{"id":130038,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18732\/revisions\/130038"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=18732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=18732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=18732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}