Format a Map Chart - Microsoft Support
Following are some guidelines for formatting a Map chart's Series Options. To display the Series Options for your map chart you can right-click on the outer portion of the map and select Format Chart Area in the right-click menu, or double-click on the outer portion of the map.
Create a Map chart in Excel - Microsoft Support
Create a Map chart with Data Types. Map charts have gotten even easier with geography data types. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to the Data tab > Data Types > Geography.
Change the display of chart axes - Microsoft Support
Display or hide axes. Click anywhere in the chart for which you want to display or hide axes. This displays the Chart Tools, adding the Design, and Format tabs. On the Design tab, click the down arrow next to Add chart elements, and then hover over Axes in the fly-out menu .
Automation add-ins for Excel are not loading after installing April ...
2021年4月28日 · Identify the name of the automation add-in that fails to load. In later steps, we will refer to this name as <ProgID>. To verify the add-in name, view your list of add-ins in the Excel Add-in Manager. From an open Excel sheet, select File, choose Options, and then choose the Add-Ins category.
Change the scale of the horizontal (category) axis in a chart
The horizontal (category) axis, also known as the x axis, of a chart displays text labels instead of numeric intervals and provides fewer scaling options than are available for a vertical (value) axis, also known as the y axis, of the chart. However, you can specify the following axis options:
How to correct a #NAME? error - Microsoft Support
The top reason why the #NAME? error appears in your formula is because there is a typo in the formula name. To avoid typos in formula names, use the Formula Wizard in Excel.
Map XML elements to cells in an XML Map - Microsoft Support
To import and export XML data in Excel, an XML Map that associates XML elements with data in cells to get the results you want will be useful. To create one, you need to have an XML schema file (.xsd) and an XML data file (.xml). After creating the XML Map, you can map XML elements the way you want.
Import XML data - Microsoft Support
Import XML data. Excel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016. If you previously created an XML Map, you can use it to import XML data into cells that are mapped, but there also are several methods and commands for importing XML data without an XML Map.
Compare workbooks using Spreadsheet Inquire - Microsoft Support
Say you want to compare versions of a workbook, analyze a workbook for problems or inconsistencies, or see links between workbooks or worksheets. If Microsoft Microsoft 365 or Office Professional Plus 2013 is installed on your computer, the Spreadsheet Inquire add-in is available in Excel.
Add a legend to a chart - Microsoft Support
Learn how to add a legend to a chart, retrieve a missing legend, and adjust its settings. Add, edit, or remove a chart legend in Excel.
Work with links in Excel - Microsoft Support
Insert a hyperlink in a worksheet cell or specific chart element to link to a related file or Web page in Excel. You can also modify or remove hyperlinks.