{"id":1760,"date":"2014-05-28T05:38:49","date_gmt":"2014-05-28T05:38:49","guid":{"rendered":"http:\/\/excelvbatutor.com\/?p=1760"},"modified":"2015-05-07T12:35:49","modified_gmt":"2015-05-07T12:35:49","slug":"creating-charts-in-excel-vba-2010","status":"publish","type":"post","link":"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/","title":{"rendered":"Creating charts in Excel VBA 2010"},"content":{"rendered":"<p>Can we write code to create charts and graphs in Excel VBA 2010? Yes, you can. Excel VBA 2010 has included charting engine as part of the Shape object. It is also an object by itself.  We can create charts on a sheet of their own or embed them into an  existing worksheet. The chart sheet is the Chart object whereas the embedded chart is part of the shape collection for the worksheet.<\/p>\n<p><a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-24-creating-charts-and-graphs\/\">Read More&#8230;&#8230;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Can we write code to create charts and graphs in Excel VBA 2010? Yes, you can. Excel VBA 2010 has included charting engine as part of the Shape object. It is also an object by itself. We can create charts on a sheet of their own or embed them into an existing worksheet. The chart &hellip; <a href=\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Creating charts in Excel VBA 2010&#8221;<\/span><\/a><\/p>\n","protected":false},"author":5012,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1760","post","type-post","status-publish","format-standard","hentry","category-general"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating charts in Excel VBA 2010 - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating charts in Excel VBA 2010 - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"og:description\" content=\"Can we write code to create charts and graphs in Excel VBA 2010? Yes, you can. Excel VBA 2010 has included charting engine as part of the Shape object. It is also an object by itself. We can create charts on a sheet of their own or embed them into an existing worksheet. The chart &hellip; Continue reading &quot;Creating charts in Excel VBA 2010&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/\" \/>\n<meta property=\"og:site_name\" content=\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-28T05:38:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-05-07T12:35:49+00:00\" \/>\n<meta name=\"author\" content=\"Liew Voon Kiong\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liew Voon Kiong\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/\"},\"author\":{\"name\":\"Liew Voon Kiong\",\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\"},\"headline\":\"Creating charts in Excel VBA 2010\",\"datePublished\":\"2014-05-28T05:38:49+00:00\",\"dateModified\":\"2015-05-07T12:35:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/\"},\"wordCount\":78,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/\",\"url\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/\",\"name\":\"Creating charts in Excel VBA 2010 - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/#website\"},\"datePublished\":\"2014-05-28T05:38:49+00:00\",\"dateModified\":\"2015-05-07T12:35:49+00:00\",\"author\":{\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\"},\"breadcrumb\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/excelvbatutor.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating charts in Excel VBA 2010\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelvbatutor.com\/#website\",\"url\":\"https:\/\/excelvbatutor.com\/\",\"name\":\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"description\":\"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\",\"name\":\"Liew Voon Kiong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g\",\"caption\":\"Liew Voon Kiong\"},\"url\":\"https:\/\/excelvbatutor.com\/index.php\/author\/ajs7051vba\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating charts in Excel VBA 2010 - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","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:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/","og_locale":"en_US","og_type":"article","og_title":"Creating charts in Excel VBA 2010 - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","og_description":"Can we write code to create charts and graphs in Excel VBA 2010? Yes, you can. Excel VBA 2010 has included charting engine as part of the Shape object. It is also an object by itself. We can create charts on a sheet of their own or embed them into an existing worksheet. The chart &hellip; Continue reading \"Creating charts in Excel VBA 2010\"","og_url":"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/","og_site_name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","article_published_time":"2014-05-28T05:38:49+00:00","article_modified_time":"2015-05-07T12:35:49+00:00","author":"Liew Voon Kiong","twitter_misc":{"Written by":"Liew Voon Kiong"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/#article","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/"},"author":{"name":"Liew Voon Kiong","@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a"},"headline":"Creating charts in Excel VBA 2010","datePublished":"2014-05-28T05:38:49+00:00","dateModified":"2015-05-07T12:35:49+00:00","mainEntityOfPage":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/"},"wordCount":78,"articleSection":["General"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/","url":"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/","name":"Creating charts in Excel VBA 2010 - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/#website"},"datePublished":"2014-05-28T05:38:49+00:00","dateModified":"2015-05-07T12:35:49+00:00","author":{"@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a"},"breadcrumb":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/excelvbatutor.com\/index.php\/2014\/05\/28\/creating-charts-in-excel-vba-2010\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/excelvbatutor.com\/"},{"@type":"ListItem","position":2,"name":"Creating charts in Excel VBA 2010"}]},{"@type":"WebSite","@id":"https:\/\/excelvbatutor.com\/#website","url":"https:\/\/excelvbatutor.com\/","name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","description":"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.","inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a","name":"Liew Voon Kiong","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g","caption":"Liew Voon Kiong"},"url":"https:\/\/excelvbatutor.com\/index.php\/author\/ajs7051vba\/"}]}},"_links":{"self":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/1760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/users\/5012"}],"replies":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/comments?post=1760"}],"version-history":[{"count":1,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/1760\/revisions"}],"predecessor-version":[{"id":1761,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/1760\/revisions\/1761"}],"wp:attachment":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/media?parent=1760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/categories?post=1760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/tags?post=1760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}