{"id":100,"date":"2026-03-06T11:06:37","date_gmt":"2026-03-06T03:06:37","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=100"},"modified":"2026-01-17T11:19:43","modified_gmt":"2026-01-17T11:19:43","slug":"how-to-set-chart-series-using-xlwings","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-set-chart-series-using-xlwings\/","title":{"rendered":"How To Set Chart Series Using xlwings?"},"content":{"rendered":"<h2>Method<\/h2>\n<p>You can set the chart type using the `chart_type` property of the chart object or the `ChartType` property of the Chart object. For a chart object `cht`, set the chart type as shown below:<\/p>\n<p>\u3010xlwings\u3011<\/p>\n<p>cht.chart_type=&#8221;column_clustered&#8221;<\/p>\n<p>\u3010xlwings API\u3011<\/p>\n<p>cht.ChartType=xw.constants.ChartType.xlColumnClustered<\/p>\n<p>The values for the `chart_type` or `ChartType` property are as shown in the table below.<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p>API Constant Name<\/p>\n<\/td>\n<td>\n<p>API Value<\/p>\n<\/td>\n<td>\n<p>xlwings Value<\/p>\n<\/td>\n<td>\n<p>Description<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DArea<\/p>\n<\/td>\n<td>\n<p>-4098<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_area&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Area Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DAreaStacked<\/p>\n<\/td>\n<td>\n<p>78<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_area_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Stacked Area Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DAreaStacked100<\/p>\n<\/td>\n<td>\n<p>79<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_area_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Area Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DBarClustered<\/p>\n<\/td>\n<td>\n<p>60<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_bar_clustered&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Clustered Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DBarStacked<\/p>\n<\/td>\n<td>\n<p>61<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_bar_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Stacked Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DBarStacked100<\/p>\n<\/td>\n<td>\n<p>62<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_bar_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Percentage Stacked Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DColumn<\/p>\n<\/td>\n<td>\n<p>-4100<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_column&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DColumnClustered<\/p>\n<\/td>\n<td>\n<p>54<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_column_clustered&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Clustered Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DColumnStacked<\/p>\n<\/td>\n<td>\n<p>55<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_column_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Stacked Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DColumnStacked100<\/p>\n<\/td>\n<td>\n<p>56<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_column_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Percentage Stacked Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DLine<\/p>\n<\/td>\n<td>\n<p>-4101<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_line&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Line Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DPie<\/p>\n<\/td>\n<td>\n<p>-4102<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_pie&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Pie Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xl3DPieExploded<\/p>\n<\/td>\n<td>\n<p>70<\/p>\n<\/td>\n<td>\n<p>&#8220;3d_pie_exploded&#8221;<\/p>\n<\/td>\n<td>\n<p>Exploded 3D Pie Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlArea<\/p>\n<\/td>\n<td>\n<p>1<\/p>\n<\/td>\n<td>\n<p>&#8220;area&#8221;<\/p>\n<\/td>\n<td>\n<p>Area Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlAreaStacked<\/p>\n<\/td>\n<td>\n<p>76<\/p>\n<\/td>\n<td>\n<p>&#8220;area_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Area Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlAreaStacked100<\/p>\n<\/td>\n<td>\n<p>77<\/p>\n<\/td>\n<td>\n<p>&#8220;area_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Area Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlBarClustered<\/p>\n<\/td>\n<td>\n<p>57<\/p>\n<\/td>\n<td>\n<p>&#8220;bar_clustered&#8221;<\/p>\n<\/td>\n<td>\n<p>Clustered Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlBarOfPie<\/p>\n<\/td>\n<td>\n<p>71<\/p>\n<\/td>\n<td>\n<p>&#8220;bar_of_pie&#8221;<\/p>\n<\/td>\n<td>\n<p>Bar of Pie Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlBarStacked<\/p>\n<\/td>\n<td>\n<p>58<\/p>\n<\/td>\n<td>\n<p>&#8220;bar_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlBarStacked100<\/p>\n<\/td>\n<td>\n<p>59<\/p>\n<\/td>\n<td>\n<p>&#8220;bar_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlBubble<\/p>\n<\/td>\n<td>\n<p>\u4e2a<\/p>\n<\/td>\n<td>\n<p>&#8220;bubble&#8221;<\/p>\n<\/td>\n<td>\n<p>Bubble Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlBubble3DEffect<\/p>\n<\/td>\n<td>\n<p>87<\/p>\n<\/td>\n<td>\n<p>&#8220;bubble_3d_effect&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Bubble Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlColumnClustered<\/p>\n<\/td>\n<td>\n<p>51<\/p>\n<\/td>\n<td>\n<p>&#8220;column_clustered&#8221;<\/p>\n<\/td>\n<td>\n<p>Clustered Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlColumnStacked<\/p>\n<\/td>\n<td>\n<p>52<\/p>\n<\/td>\n<td>\n<p>&#8220;column_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlColumnStacked100<\/p>\n<\/td>\n<td>\n<p>53<\/p>\n<\/td>\n<td>\n<p>&#8220;column_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlConeBarClustered<\/p>\n<\/td>\n<td>\n<p>102<\/p>\n<\/td>\n<td>\n<p>&#8220;cone_bar_clustered&#8221;<\/p>\n<\/td>\n<td>\n<p>Clustered Cone Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlConeBarStacked<\/p>\n<\/td>\n<td>\n<p>103<\/p>\n<\/td>\n<td>\n<p>&#8220;cone_bar_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Cone Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlConeBarStacked100<\/p>\n<\/td>\n<td>\n<p>104<\/p>\n<\/td>\n<td>\n<p>&#8220;cone_bar_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Cone Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlConeCol<\/p>\n<\/td>\n<td>\n<p>105<\/p>\n<\/td>\n<td>\n<p>&#8220;cone_col&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Cone Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlConeColClustered<\/p>\n<\/td>\n<td>\n<p>99<\/p>\n<\/td>\n<td>\n<p>&#8220;cone_col_clustered&#8221;<\/p>\n<\/td>\n<td>\n<p>Clustered Cone Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlConeColStacked<\/p>\n<\/td>\n<td>\n<p>100<\/p>\n<\/td>\n<td>\n<p>&#8220;cone_col_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Cone Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlConeColStacked100<\/p>\n<\/td>\n<td>\n<p>101<\/p>\n<\/td>\n<td>\n<p>&#8220;cone_col_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Cone Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlCylinderBarClustered<\/p>\n<\/td>\n<td>\n<p>95<\/p>\n<\/td>\n<td>\n<p>&#8220;cylinder_bar_clustered&#8221;<\/p>\n<\/td>\n<td>\n<p>Clustered Cylinder Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlCylinderBarStacked<\/p>\n<\/td>\n<td>\n<p>96<\/p>\n<\/td>\n<td>\n<p>&#8220;cylinder_bar_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Cylinder Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlCylinderBarStacked100<\/p>\n<\/td>\n<td>\n<p>97<\/p>\n<\/td>\n<td>\n<p>&#8220;cylinder_bar_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Cylinder Bar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlCylinderCol<\/p>\n<\/td>\n<td>\n<p>98<\/p>\n<\/td>\n<td>\n<p>&#8220;cylinder_col&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Cylinder Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlCylinderColClustered<\/p>\n<\/td>\n<td>\n<p>92<\/p>\n<\/td>\n<td>\n<p>&#8220;cylinder_col_clustered&#8221;<\/p>\n<\/td>\n<td>\n<p>Clustered Cylinder Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlCylinderColStacked<\/p>\n<\/td>\n<td>\n<p>93<\/p>\n<\/td>\n<td>\n<p>&#8220;cylinder_col_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Cylinder Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlCylinderColStacked100<\/p>\n<\/td>\n<td>\n<p>94<\/p>\n<\/td>\n<td>\n<p>&#8220;cylinder_col_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Cylinder Column Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlDoughnut<\/p>\n<\/td>\n<td>\n<p>-4120<\/p>\n<\/td>\n<td>\n<p>&#8220;doughnut&#8221;<\/p>\n<\/td>\n<td>\n<p>Doughnut Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlDoughnutExploded<\/p>\n<\/td>\n<td>\n<p>80<\/p>\n<\/td>\n<td>\n<p>&#8220;doughnut_exploded&#8221;<\/p>\n<\/td>\n<td>\n<p>Exploded Doughnut Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlLine<\/p>\n<\/td>\n<td>\n<p>4<\/p>\n<\/td>\n<td>\n<p>&#8220;line&#8221;<\/p>\n<\/td>\n<td>\n<p>Line Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlLineMarkers<\/p>\n<\/td>\n<td>\n<p>65<\/p>\n<\/td>\n<td>\n<p>&#8220;line_markers&#8221;<\/p>\n<\/td>\n<td>\n<p>Line Chart with Data Markers<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlLineMarkersStacked<\/p>\n<\/td>\n<td>\n<p>66<\/p>\n<\/td>\n<td>\n<p>&#8220;line_markers_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Line Chart with Data Markers<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlLineMarkersStacked100<\/p>\n<\/td>\n<td>\n<p>67<\/p>\n<\/td>\n<td>\n<p>&#8220;line_markers_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Line Chart with Data Markers<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlLineStacked<\/p>\n<\/td>\n<td>\n<p>63<\/p>\n<\/td>\n<td>\n<p>&#8220;line_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Line Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlLineStacked100<\/p>\n<\/td>\n<td>\n<p>64<\/p>\n<\/td>\n<td>\n<p>&#8220;line_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Line Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlPie<\/p>\n<\/td>\n<td>\n<p>5<\/p>\n<\/td>\n<td>\n<p>&#8220;pie&#8221;<\/p>\n<\/td>\n<td>\n<p>Pie Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlPieExploded<\/p>\n<\/td>\n<td>\n<p>69<\/p>\n<\/td>\n<td>\n<p>&#8220;pie_exploded&#8221;<\/p>\n<\/td>\n<td>\n<p>Exploded Pie Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlPieOfPie<\/p>\n<\/td>\n<td>\n<p>68<\/p>\n<\/td>\n<td>\n<p>&#8220;pie_of_pie&#8221;<\/p>\n<\/td>\n<td>\n<p>Pie of Pie Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlPyramidBarClustered<\/p>\n<\/td>\n<td>\n<p>109<\/p>\n<\/td>\n<td>\n<p>&#8220;pyramid_bar_clustered&#8221;<\/p>\n<\/td>\n<td>\n<p>Compound Bar Pyramid Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlPyramidBarStacked<\/p>\n<\/td>\n<td>\n<p>110<\/p>\n<\/td>\n<td>\n<p>&#8220;pyramid_bar_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Bar Pyramid Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlPyramidBarStacked100<\/p>\n<\/td>\n<td>\n<p>111<\/p>\n<\/td>\n<td>\n<p>&#8220;pyramid_bar_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Bar Pyramid Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlPyramidCol<\/p>\n<\/td>\n<td>\n<p>112<\/p>\n<\/td>\n<td>\n<p>&#8220;pyramid_col&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Column Pyramid Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlPyramidColClustered<\/p>\n<\/td>\n<td>\n<p>106<\/p>\n<\/td>\n<td>\n<p>&#8220;pyramid_col_clustered&#8221;<\/p>\n<\/td>\n<td>\n<p>Compound Column Pyramid Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlPyramidColStacked<\/p>\n<\/td>\n<td>\n<p>107<\/p>\n<\/td>\n<td>\n<p>&#8220;pyramid_col_stacked&#8221;<\/p>\n<\/td>\n<td>\n<p>Stacked Column Pyramid Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlPyramidColStacked100<\/p>\n<\/td>\n<td>\n<p>108<\/p>\n<\/td>\n<td>\n<p>&#8220;pyramid_col_stacked_100&#8221;<\/p>\n<\/td>\n<td>\n<p>Percentage Stacked Column Pyramid Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlRadar<\/p>\n<\/td>\n<td>\n<p>-4151<\/p>\n<\/td>\n<td>\n<p>&#8220;radar&#8221;<\/p>\n<\/td>\n<td>\n<p>Radar Chart.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlRadarFilled<\/p>\n<\/td>\n<td>\n<p>82<\/p>\n<\/td>\n<td>\n<p>&#8220;radar_filled&#8221;<\/p>\n<\/td>\n<td>\n<p>Filled Radar Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlRadarMarkers<\/p>\n<\/td>\n<td>\n<p>81<\/p>\n<\/td>\n<td>\n<p>&#8220;radar_markers&#8221;<\/p>\n<\/td>\n<td>\n<p>Radar Chart with Data Markers<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlRegionMap<\/p>\n<\/td>\n<td>\n<p>140<\/p>\n<\/td>\n<td>\n<p>\u00a0<\/p>\n<\/td>\n<td>\n<p>Map Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlStockHLC<\/p>\n<\/td>\n<td>\n<p>88<\/p>\n<\/td>\n<td>\n<p>&#8220;stock_hlc&#8221;<\/p>\n<\/td>\n<td>\n<p>High-Low-Close Stock Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlStockOHLC<\/p>\n<\/td>\n<td>\n<p>89<\/p>\n<\/td>\n<td>\n<p>&#8220;stock_ohlc&#8221;<\/p>\n<\/td>\n<td>\n<p>Open-High-Low-Close Stock Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlStockVHLC<\/p>\n<\/td>\n<td>\n<p>90<\/p>\n<\/td>\n<td>\n<p>&#8220;stock_vhlc&#8221;<\/p>\n<\/td>\n<td>\n<p>Volume-High-Low-Close Stock Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlStockVOHLC<\/p>\n<\/td>\n<td>\n<p>91<\/p>\n<\/td>\n<td>\n<p>&#8220;stock_vohlc&#8221;<\/p>\n<\/td>\n<td>\n<p>Volume-Open-High-Low-Close Stock Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlSurface<\/p>\n<\/td>\n<td>\n<p>83<\/p>\n<\/td>\n<td>\n<p>&#8220;surface&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Surface Chart<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlSurfaceTopView<\/p>\n<\/td>\n<td>\n<p>85<\/p>\n<\/td>\n<td>\n<p>&#8220;surface_top_view&#8221;<\/p>\n<\/td>\n<td>\n<p>Surface Chart (Top View)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlSurfaceTopViewWireframe<\/p>\n<\/td>\n<td>\n<p>86<\/p>\n<\/td>\n<td>\n<p>&#8220;surface_top_view_wireframe&#8221;<\/p>\n<\/td>\n<td>\n<p>Surface Chart (Top View Wireframe)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlSurfaceWireframe<\/p>\n<\/td>\n<td>\n<p>84<\/p>\n<\/td>\n<td>\n<p>&#8220;surface_wireframe&#8221;<\/p>\n<\/td>\n<td>\n<p>3D Surface Chart (Wireframe)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlXYScatter<\/p>\n<\/td>\n<td>\n<p>-4169<\/p>\n<\/td>\n<td>\n<p>&#8220;xy_scatter&#8221;<\/p>\n<\/td>\n<td>\n<p>Scatter Plot<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlXYScatterLines<\/p>\n<\/td>\n<td>\n<p>74<\/p>\n<\/td>\n<td>\n<p>&#8220;xy_scatter_lines&#8221;<\/p>\n<\/td>\n<td>\n<p>Line Scatter Plot<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlXYScatterLinesNoMarkers<\/p>\n<\/td>\n<td>\n<p>75<\/p>\n<\/td>\n<td>\n<p>&#8220;xy_scatter_lines_no_markers&#8221;<\/p>\n<\/td>\n<td>\n<p>Line Scatter Plot Without Markers<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlXYScatterSmooth<\/p>\n<\/td>\n<td>\n<p>72<\/p>\n<\/td>\n<td>\n<p>&#8220;xy_scatter_smooth&#8221;<\/p>\n<\/td>\n<td>\n<p>Smooth Line Scatter Plot<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>xlXYScatterSmoothNoMarkers<\/p>\n<\/td>\n<td>\n<p>73<\/p>\n<\/td>\n<td>\n<p>&#8220;xy_scatter_smooth_no_markers&#8221;<\/p>\n<\/td>\n<td>\n<p>Smooth Line Scatter Plot Without Markers<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a0<\/p>\n<p>sht.api.Range(&#8216;A1&#8217;).CurrentRegion.Select()\u00a0\u00a0\u00a0 #Data<\/p>\n<p>sht.api.Shapes.AddChart2(-1,xw.constants.ChartType.xlColumnClustered,20,150,300,200,True)<\/p>\n<h2>Sample Code<\/h2>\n\n\n<pre class=\"wp-block-code\"><code>#Chart type\n\nimport xlwings as xw\nimport os\n\nroot = os.getcwd()\napp = xw.App(visible=True, add_book=False)\nwb=app.books.open('GDP.xlsx',read_only=False)\nsht=wb.sheets(1)\n\nsht.api.Range('A1').CurrentRegion.Select()    #Data\nsht.api.Shapes.AddChart2(-1,xw.constants.ChartType.xlColumnClustered,20,150,300,200,True)\nsht.api.Shapes.AddChart2(-1,xw.constants.ChartType.xlBarClustered,400,150,300,200,True)\nsht.api.Shapes.AddChart2(-1,xw.constants.ChartType.xlConeBarStacked,20,400,300,200,True)\nsht.api.Shapes.AddChart2(-1,xw.constants.ChartType.xlLineMarkersStacked,400,400,300,200,True)\nsht.api.Shapes.AddChart2(-1,xw.constants.ChartType.xlXYScatter,20,650,300,200,True)\nsht.api.Shapes.AddChart2(-1,xw.constants.ChartType.xlPieOfPie,400,650,300,200,True)\n\n#wb.save()\n#wb.close()\n#app.kill()<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"883\" height=\"737\" src=\"https:\/\/xlwings.net\/blog\/wp-content\/uploads\/2026\/03\/image-9.png\" alt=\"Set Chart Series Using xlwings\" class=\"wp-image-484\" srcset=\"https:\/\/xlwings.net\/blog\/wp-content\/uploads\/2026\/03\/image-9.png 883w, https:\/\/xlwings.net\/blog\/wp-content\/uploads\/2026\/03\/image-9-300x250.png 300w, https:\/\/xlwings.net\/blog\/wp-content\/uploads\/2026\/03\/image-9-768x641.png 768w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Method<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-100","post","type-post","status-publish","format-standard","hentry","category-xlwings-chart"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/comments?post=100"}],"version-history":[{"count":2,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/100\/revisions"}],"predecessor-version":[{"id":485,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/100\/revisions\/485"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}