How to use excel map charts

Have you ever put map graphics into excel? Friends who don’t have it, take a look here. It contains some tips on how to use EXCEL functions, such as how to use filtering and adjustment functions. Today I will share with my friends an example of an excel map chart. If you are interested, please come and study it carefully!

Open the Excel software, enter the chart interface, click the insert option, select the three-dimensional map demonstration, and then click New Demonstration. Then drag the order amount field to the height option and follow the icon.

2. Drag [Product] to [Type] and drag [Order Date] to [Time], as shown in the figure.

3. Click [Filter], click [Add Filter] model, and select [Model] to filter, as shown in the figure.

4. [Chart Options] You can adjust [Height] and [Thickness], select [Color], and adjust [Color], as shown in the figure.

5. Click [New Scene], select the [Beijing] location, click [New Scene] again, select the [Wuhan] location, and adjust the [Angle], as shown in the figure Show.

6. Click [Scene Options], adjust the [Effect] circle, and click [Play Demo] to perform a demonstration, as shown in the figure

The above is the detailed content of How to use excel map charts. For more information, please follow other related articles on the PHP Chinese website!