![]() ![]() The free app is exactly the same as its Windows’ counterpart, and has all the tools you’d find in the Paint app, right down to the spray can. If you want to display geographical data on your Excel sheet, the map chart is a terrific visual tool.If you’re looking for an app that works exactly the way Paint does on Windows, look no further than Paintbrush. Select the chart and hit your Delete key or right-click and pick “Cut.” If you decide that you don’t want to use the map chart after all, you can remove it easily. To edit the data that displays on the map, for example, if you add more locations, right-click the chart and click “Select Data.” Alternatively, you can go to the “Chart Design” tab and click “Select Data” in the ribbon.Įnter the cells in the “Chart Data Range” box at the top, or drag your cursor through the cells. And to resize the chart, drag one of the corners or edges. You can easily move the map chart anywhere you want on your sheet. Whichever you choose, you’ll see your map update immediately. Click “Styles” to scroll through premade themes or “Color” to pick a colorful or monochromatic scheme. Select the chart and click “Chart Styles” (found on the paintbrush) on the right. The map chart is pretty basic in its color, but you can spruce it up with a theme or color scheme. You can also select “More Legend Options” to open the sidebar and format the text and additional options. Hover your cursor over the arrow to the right of “Legend” in the Chart Elements box and choose a position for the legend. Select the chart and click “Chart Elements” on the right. This useful tool is a key to the data that displays on the chart. One more helpful element for almost any chart is a legend. To adjust the text and options for the labels, select “More Data Label Options.” Like with the chart title, the right-hand sidebar will open with formatting features for the labels. These will show the data directly on each map location. If the data you’re displaying on the map is small enough, you may want to In this spot, you can choose the position, use a fill color, or apply a text outline. You can also select “More Title Options,” which will display a sidebar on the right. Hover your cursor over the arrow to the right of “Chart Title” in the Chart Elements box and choose a different position for the title if you like. Check the box for “Chart Title,” then enter the title in the text box that appears on the map. Select the chart and click “Chart Elements” (“+” icon) on the right. If the map does not include a title, you can add one easily as well as changing its position. If your map contains the default “Chart Title,” you can simply click that text box on the map and type in your own title. ![]() ![]() You can add a title, some labels, a legend, and a style. The next steps include formatting your map to include useful components and a color scheme. Your newly created chart will pop right onto your sheet with your data mapped. Click the drop-down for “Maps” and choose “Filled Map.” When you’re ready to create the map chart, select your data by dragging through the cells, open the “Insert” tab, and move to the “Charts” section of the ribbon. The map chart in Excel works best with large areas like counties, states, regions, countries, and continents. You’ll only see dots representing those types of locations. While you can use the chart for smaller areas, such as cities, the map won’t be as effective. Or, alternately, it might be your sales amounts, number of stores, average operating costs, or other data you have already prepared in your spreadsheet. Like the examples listed above, this can be the population or abbreviation that you can obtain from the This allows you to select the cells containing that data and simply insert the chart for it. Like with other chart types in Microsoft Excel, it’s best to start with populated data. You can then format it with labels, a legend, and an appropriate color scheme. Whether you want to display populations in several countries for your sales team or abbreviations for the United States for your elementary school class, you can create a map chart easily in Microsoft Excel. So for geographical data, why not use the map chart type in Microsoft Excel? They can make viewing and analyzing data easier, especially for your audience. Charts are helpful for visual displays of your data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |