http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-24-creating-charts-and-graphs\/<\/a><\/p>\n <\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
In Excel VBA 2010, we can write code to create charts and graphs easily based on the data on the spreadsheet. Excel 2010 has made 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 … Continue reading “Creating Charts and Graphs in Excel VBA 2010”<\/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-2150","post","type-post","status-publish","format-standard","hentry","category-general"],"yoast_head":"\nCreating Charts and Graphs in Excel VBA 2010 - Excel VBA<\/title>\n<meta name=\"description\" content=\"This article discusses how to create charts and graphs in excel vba 2010\" \/>\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\/2015\/10\/27\/creating-charts-and-graphs-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 and Graphs in Excel VBA 2010 - Excel VBA\" \/>\n<meta property=\"og:description\" content=\"This article discusses how to create charts and graphs in excel vba 2010\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/\" \/>\n<meta property=\"og:site_name\" content=\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials & Courses | ExcelVBATutor\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-27T02:56:48+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\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/\"},\"author\":{\"name\":\"Liew Voon Kiong\",\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\"},\"headline\":\"Creating Charts and Graphs in Excel VBA 2010\",\"datePublished\":\"2015-10-27T02:56:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/\"},\"wordCount\":98,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/\",\"url\":\"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/\",\"name\":\"Creating Charts and Graphs in Excel VBA 2010 - Excel VBA\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/#website\"},\"datePublished\":\"2015-10-27T02:56:48+00:00\",\"author\":{\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\"},\"description\":\"This article discusses how to create charts and graphs in excel vba 2010\",\"breadcrumb\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/excelvbatutor.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating Charts and Graphs 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 & 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 and Graphs in Excel VBA 2010 - Excel VBA","description":"This article discusses how to create charts and graphs in excel vba 2010","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\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/","og_locale":"en_US","og_type":"article","og_title":"Creating Charts and Graphs in Excel VBA 2010 - Excel VBA","og_description":"This article discusses how to create charts and graphs in excel vba 2010","og_url":"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/","og_site_name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials & Courses | ExcelVBATutor","article_published_time":"2015-10-27T02:56:48+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\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/#article","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/"},"author":{"name":"Liew Voon Kiong","@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a"},"headline":"Creating Charts and Graphs in Excel VBA 2010","datePublished":"2015-10-27T02:56:48+00:00","mainEntityOfPage":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/"},"wordCount":98,"articleSection":["General"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/","url":"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/","name":"Creating Charts and Graphs in Excel VBA 2010 - Excel VBA","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/#website"},"datePublished":"2015-10-27T02:56:48+00:00","author":{"@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a"},"description":"This article discusses how to create charts and graphs in excel vba 2010","breadcrumb":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/excelvbatutor.com\/index.php\/2015\/10\/27\/creating-charts-and-graphs-in-excel-vba-2010\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/excelvbatutor.com\/"},{"@type":"ListItem","position":2,"name":"Creating Charts and Graphs 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 & 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\/2150","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=2150"}],"version-history":[{"count":1,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/2150\/revisions"}],"predecessor-version":[{"id":2151,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/2150\/revisions\/2151"}],"wp:attachment":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/media?parent=2150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/categories?post=2150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/tags?post=2150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}