{"id":20777,"date":"2024-03-15T20:56:12","date_gmt":"2024-03-15T20:56:12","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/"},"modified":"2024-03-21T18:54:17","modified_gmt":"2024-03-21T18:54:17","slug":"how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/","title":{"rendered":"How can one alter the data of a chart in a docx document using Python?"},"content":{"rendered":"<p>To update the chart data in a docx document, you can use the python-docx library to operate. <\/p>\n<p>First, to install the python-docx library, you can use the following command:<\/p>\n<pre class=\"post-pre\"><code>pip install python-docx\r\n<\/code><\/pre>\n<p>Next, you can use the following code example to modify the data in charts of a docx document.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">from<\/span> docx <span class=\"hljs-keyword\">import<\/span> Document\r\n<span class=\"hljs-keyword\">from<\/span> docx.chart <span class=\"hljs-keyword\">import<\/span> CategoryChartData\r\n\r\n<span class=\"hljs-comment\"># \u6253\u5f00docx\u6587\u6863<\/span>\r\ndoc = Document(<span class=\"hljs-string\">'example.docx'<\/span>)\r\n\r\n<span class=\"hljs-comment\"># \u904d\u5386\u6587\u6863\u4e2d\u7684\u56fe\u8868<\/span>\r\n<span class=\"hljs-keyword\">for<\/span> chart <span class=\"hljs-keyword\">in<\/span> doc.inline_shapes:\r\n    <span class=\"hljs-keyword\">if<\/span> chart.has_chart:\r\n        <span class=\"hljs-comment\"># \u83b7\u53d6\u56fe\u8868\u5bf9\u8c61<\/span>\r\n        chart_obj = chart.chart\r\n        <span class=\"hljs-comment\"># \u68c0\u67e5\u56fe\u8868\u7c7b\u578b<\/span>\r\n        <span class=\"hljs-keyword\">if<\/span> chart_obj.chart_type == <span class=\"hljs-string\">'BarChart'<\/span>:  <span class=\"hljs-comment\"># \u5047\u8bbe\u56fe\u8868\u7c7b\u578b\u4e3a\u67f1\u5f62\u56fe<\/span>\r\n            <span class=\"hljs-comment\"># \u4fee\u6539\u56fe\u8868\u6570\u636e<\/span>\r\n            chart_data = CategoryChartData()\r\n            chart_data.categories = [<span class=\"hljs-string\">'A'<\/span>, <span class=\"hljs-string\">'B'<\/span>, <span class=\"hljs-string\">'C'<\/span>]  <span class=\"hljs-comment\"># x\u8f74\u6570\u636e<\/span>\r\n            chart_data.add_series(<span class=\"hljs-string\">'Series 1'<\/span>, (<span class=\"hljs-number\">1<\/span>, <span class=\"hljs-number\">2<\/span>, <span class=\"hljs-number\">3<\/span>))  <span class=\"hljs-comment\"># y\u8f74\u6570\u636e<\/span>\r\n            chart_obj.replace_data(chart_data)\r\n\r\n<span class=\"hljs-comment\"># \u4fdd\u5b58\u4fee\u6539\u540e\u7684\u6587\u6863<\/span>\r\ndoc.save(<span class=\"hljs-string\">'modified_example.docx'<\/span>)\r\n<\/code><\/pre>\n<p>In the above example, we opened a docx document named example.docx, traversed the charts within it, checked if the chart type is a bar chart. Next, we created a new chart data object CategoryChartData, and set the data for the x and y axes. Finally, we applied the modified data to the chart using the replace_data method. The modified document is saved as modified_example.docx.<\/p>\n<p>Please note that this is just a basic example, and modifications may be necessary based on the specific charts and data structures used in actual applications. Specific chart types and data structures can be understood by consulting the documentation of the python-docx library.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To update the chart data in a docx document, you can use the python-docx library to operate. First, to install the python-docx library, you can use the following command: pip install python-docx Next, you can use the following code example to modify the data in charts of a docx document. from docx import Document from [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-20777","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can one alter the data of a chart in a docx document using Python? - Blog - Silicon Cloud<\/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:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can one alter the data of a chart in a docx document using Python?\" \/>\n<meta property=\"og:description\" content=\"To update the chart data in a docx document, you can use the python-docx library to operate. First, to install the python-docx library, you can use the following command: pip install python-docx Next, you can use the following code example to modify the data in charts of a docx document. from docx import Document from [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T20:56:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T18:54:17+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sophia Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"How can one alter the data of a chart in a docx document using Python?\",\"datePublished\":\"2024-03-15T20:56:12+00:00\",\"dateModified\":\"2024-03-21T18:54:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/\"},\"wordCount\":173,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/\",\"name\":\"How can one alter the data of a chart in a docx document using Python? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T20:56:12+00:00\",\"dateModified\":\"2024-03-21T18:54:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can one alter the data of a chart in a docx document using Python?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can one alter the data of a chart in a docx document using Python? - Blog - Silicon Cloud","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.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/","og_locale":"en_US","og_type":"article","og_title":"How can one alter the data of a chart in a docx document using Python?","og_description":"To update the chart data in a docx document, you can use the python-docx library to operate. First, to install the python-docx library, you can use the following command: pip install python-docx Next, you can use the following code example to modify the data in charts of a docx document. from docx import Document from [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T20:56:12+00:00","article_modified_time":"2024-03-21T18:54:17+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"How can one alter the data of a chart in a docx document using Python?","datePublished":"2024-03-15T20:56:12+00:00","dateModified":"2024-03-21T18:54:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/"},"wordCount":173,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/","name":"How can one alter the data of a chart in a docx document using Python? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T20:56:12+00:00","dateModified":"2024-03-21T18:54:17+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-one-alter-the-data-of-a-chart-in-a-docx-document-using-python\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can one alter the data of a chart in a docx document using Python?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/20777","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=20777"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/20777\/revisions"}],"predecessor-version":[{"id":54598,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/20777\/revisions\/54598"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=20777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=20777"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=20777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}