Return to site

Add an x and y label in excel for mac

broken image
broken image

Until recently, custom labels required either a lot of manual work to change the default text, which was not sustainable for large amounts of data, or the use of macros or third-party add-ons. One omission that annoyed me several times is the fact that in XY scatter (and bubble) charts you can’t automatically label data points with text from a third column it’s only possible to show the value of the X or Y point. Despite the impossibly long list of features and settings in Microsoft’s Excel, the most popular spreadsheet suite still lacks some features that seem trivial, or they require complicated workarounds and possibly some knowledge of VBA.