How to Import an Excel Chart Into MapInfo
When it comes to communicating data, a map that displays geographic data as well as numeric figures can be a more effective visual than a basic chart with raw numbers -- hence the prevalence of software that allows you to place chart data into geographic maps. One type of software that does this is MapInfo. Among its features is the ability to import data saved in a number of different file formats, including Microsoft Excel's ".xls" file type.
Save your Excel file to your computer. To do so, have the file open within Excel and then click File, and then "Save As." Give the file a name, ensure that "Microsoft Excel (.xls)" is selected in the "Save File as Type" dropdown menu, and then click "Save." You can then close your Excel program.
Open MapInfo, select the File menu and then select "Open."
Locate the Excel file you want to import from the files and folders on your computer, select "Microsoft Excel (.xls)" from the "Select Files of Type" dropdown menu and then click "Open." This will open an "Excel Information" dialog box.
Select the columns or rows of the Excel worksheet you would like to use by clicking on the desired title in the "Named Range" menu and then clicking "OK."
急速PC28彩票Select the Name, Type and Width for each column in the Field Properties section that appears and then click "OK."
- When you import the Excel file in this way, you will not be able to alter the contents of the file. If you want to create a copy that you can alter, click the "Create copy in MapInfo format for read/write" box located in the "Open" box detailed in Step 2.
- Hemera Technologies/Photos.com/Getty Images