{"id":534,"date":"2026-04-05T11:27:11","date_gmt":"2026-04-05T03:27:11","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=534"},"modified":"2026-03-23T07:48:55","modified_gmt":"2026-03-23T07:48:55","slug":"how-to-set-crosses-using-xlwings","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-set-crosses-using-xlwings\/","title":{"rendered":"How To Set Crosses Using xlwings?"},"content":{"rendered":"

\u3010<\/span>Method<\/span>\u3011<\/span><\/p>\n

Use the **AxisBetweenCategories** property of the **Axis** object to set the intersection point between the value axis and the category axis. If the value is `True`, the intersection occurs in the middle of the categories; if it is `False`, the intersection occurs at the middle point of the categories.<\/p>\n

\u00a0<\/p>\n

The **Crosses** property of the **Axis** object returns or sets the point at which the axis intersects with another axis. The possible values for this property are as follows:<\/p>\n

\u00a0<\/p>\n

\n\n\n\n\n\n\n\n
\n

Name<\/p>\n<\/td>\n

\n

Value<\/p>\n<\/td>\n

\n

Description<\/p>\n<\/td>\n<\/tr>\n

\n

xlAxisCrossesAutomatic<\/p>\n<\/td>\n

\n

-4105<\/p>\n<\/td>\n

\n

Automatically set by Excel<\/p>\n<\/td>\n<\/tr>\n

\n

xlAxisCrossesCustom<\/p>\n<\/td>\n

\n

-4114<\/p>\n<\/td>\n

\n

Set by **CrossesAt** property<\/p>\n<\/td>\n<\/tr>\n

\n

xlAxisCrossesMaximum<\/p>\n<\/td>\n

\n

2<\/p>\n<\/td>\n

\n

Axis crosses at maximum value<\/p>\n<\/td>\n<\/tr>\n

\n

xlAxisCrossesMinimum<\/p>\n<\/td>\n

\n

4<\/p>\n<\/td>\n

\n

Axis crosses at minimum value<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u00a0<\/p>\n

sht.api.Range(‘A1:B7’).Select()<\/p>\n

cht=sht.api.Shapes.AddChart().Chart<\/p>\n

axs2=cht.Axes(2)<\/p>\n

axs2.Crosses=2<\/p>\n

#axs2.Crosses=-4114<\/p>\n

#axs2.CrossesAt=50<\/p>\n

\u00a0<\/p>\n

\u3010<\/span>Example<\/span>\u3011<\/span><\/p>\n\n\n

\"\"<\/figure>\n\n\n\n

\u3010Code<\/strong>\u3011<\/p>\n\n\n\n

import xlwings as xw\nimport os\n\nroot=os.getcwd()\napp=xw.App(visible=True,add_book=False)\nwb=app.books.open(root+r'\/data2.xlsx',read_only=False)\nsht=wb.sheets('Sheet1')\n\nsht.api.Range('A1:B7').Select()    #\nshp=sht.api.Shapes.AddChart()    #\nshp.Left=20\ncht=shp.Chart\naxs=cht.Axes(1)    #\naxs.Border.ColorIndex=3    #\naxs.Border.Weight=3    #\naxs2=cht.Axes(2)    #\naxs.Crosses=xw.constants.AxisCrosses.xlAxisCrossesMaximum\naxs2.CrossesAt=10\n\n#wb.save()\n#app.kill()<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
Method<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-534","post","type-post","status-publish","format-standard","hentry","category-xlwings-chart"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/534","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/comments?post=534"}],"version-history":[{"count":2,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/534\/revisions"}],"predecessor-version":[{"id":1179,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/534\/revisions\/1179"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}