{"id":1790052,"date":"2022-12-08T12:33:44","date_gmt":"2022-12-08T20:33:44","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1790052"},"modified":"2024-10-18T16:44:56","modified_gmt":"2024-10-18T23:44:56","slug":"pivot-table-data-in-arcgis-for-excel-map","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map","title":{"rendered":"Visualize Aggregated Pivot Table data in ArcGIS for Excel"},"author":252692,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341],"tags":[766102,768162,768172,445032],"industry":[],"product":[766382],"class_list":["post-1790052","blog","type-blog","status-publish","format-standard","hentry","category-analytics","tag-arcgis-for-excel","tag-data-aggregation","tag-display-pivot-table-data-in-arcgis-for-excel-map","tag-pivot-table","product-arcgis-for-excel"],"acf":{"short_description":"Visualize Pivot table data in ArcGIS for Excel Map. ","flexible_content":[{"acf_fc_layout":"content","content":"

This blog article was last updated on Oct 18, 2024<\/em><\/p>\n

Pivot tables are one of the most valuable features in Excel. In the latest release, ArcGIS for Excel added support for Pivot tables. A Pivot table is a Microsoft Excel tool that can be used to create a summarized table of aggregated data. Data can be sorted, filtered, and rearranged dynamically to emphasize different aspects of your data. ArcGIS for Excel can now add the data from Pivot tables for visualization on the map.<\/p>\n

Did you know? The pivot table was actually invented by Pito Salas in 1986 at Lotus Corp<\/p>\n

 <\/p>\n

Create Pivot table in Excel<\/strong><\/p>\n

Using a sample dataset, in tabular format we can look at using a pivot table to aggregate data to areas to create a map in Excel.<\/p>\n

The sample dataset contains 100 records with 6 columns, with data for US (United States) store locations, customers visiting those locations, and store sales by customer. It is best practice – Instead of creating a pivot table from raw cell ranges, try to convert your data into a table format. A table format dataset will help you greatly when it comes to updating your Pivot table with new data in the future.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2536512,"id":2536512,"title":"PivotTable1","filename":"PivotTable1.png","filesize":233517,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\/pivottable1","alt":"","author":"252692","description":"","caption":"","name":"pivottable1","status":"inherit","uploaded_to":1790052,"date":"2024-10-18 20:32:11","modified":"2024-10-18 20:32:11","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":883,"height":488,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable1.png","medium-width":464,"medium-height":256,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable1.png","medium_large-width":768,"medium_large-height":424,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable1.png","large-width":883,"large-height":488,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable1.png","1536x1536-width":883,"1536x1536-height":488,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable1.png","2048x2048-width":883,"2048x2048-height":488,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable1-826x456.png","card_image-width":826,"card_image-height":456,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable1.png","wide_image-width":883,"wide_image-height":488}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

To insert a Pivot table, click inside your dataset. We have a table of sales data of store locations spread across United States in our sample dataset. In Excel, go to Insert tab and click Pivot table. Place the Pivot table in a New Worksheet. Then click on OK.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1790132,"id":1790132,"title":"New_PivotTable","filename":"New_PivotTable.png","filesize":40831,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/New_PivotTable.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\/new_pivottable","alt":"","author":"252692","description":"","caption":"","name":"new_pivottable","status":"inherit","uploaded_to":1790052,"date":"2022-12-08 19:04:05","modified":"2022-12-08 19:04:05","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":402,"height":261,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/New_PivotTable-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/New_PivotTable.png","medium-width":402,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/New_PivotTable.png","medium_large-width":402,"medium_large-height":261,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/New_PivotTable.png","large-width":402,"large-height":261,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/New_PivotTable.png","1536x1536-width":402,"1536x1536-height":261,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/New_PivotTable.png","2048x2048-width":402,"2048x2048-height":261,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/New_PivotTable.png","card_image-width":402,"card_image-height":261,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/New_PivotTable.png","wide_image-width":402,"wide_image-height":261}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Once you click OK, you get a Pivot table in the new sheet. One of the benefits of using a Pivot table is the ability to create and choose fields you wish to analyze. In the Pivot Table Field List Task pane, the field names are headers from the data set \u2013 STORE, CITY, YEAR, SALES, etc., are listed. The selected field can be placed in one of four sections \u2013 Filters, Columns, Rows, and Values.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1790462,"id":1790462,"title":"PivotTableEditor","filename":"PivotTableEditor-1.png","filesize":69351,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditor-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\/pivottableeditor-2","alt":"","author":"252692","description":"","caption":"","name":"pivottableeditor-2","status":"inherit","uploaded_to":1790052,"date":"2022-12-08 20:19:30","modified":"2022-12-08 20:19:30","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":624,"height":459,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditor-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditor-1.png","medium-width":355,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditor-1.png","medium_large-width":624,"medium_large-height":459,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditor-1.png","large-width":624,"large-height":459,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditor-1.png","1536x1536-width":624,"1536x1536-height":459,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditor-1.png","2048x2048-width":624,"2048x2048-height":459,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditor-1.png","card_image-width":624,"card_image-height":459,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditor-1.png","wide_image-width":624,"wide_image-height":459}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Drag the fields to relevant sections – Rows, Columns, and Values based on the type of report you want to create. You can summarize your data in a Pivot table by placing a field in \u2211 Values section in the Pivot table Field List Task pane. By default, Excel takes the summarization as sum of the values of the field in \u2211 VALUES area. However, you have other calculation types, such as, Count, Average, Max, Min, etc. Here we are creating a report where Rows are the Cities, Columns are Sales, and the \u2211 Value inside the pivot table would be the Sum of Sales by Stores and Count of Store. The Count of Store indicates the number of customers who purchase items from the Store. In the \u2211 Values section Count of Store, the field name is renamed to Total Customers. Apply the Currency formatting to the Sum of SALES column. The fields in the Rows section would be used as a Location type in ArcGIS for Excel to create a map. Now it is easier to analyze the information. Each store location is listed once, total sales are calculated, total customers counted are calculated, and grand total sales from all the stores are also counted in the Pivot table. The Pivot table would look like the screenshot below.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2536622,"id":2536622,"title":"PivotTableEditorScreenshot2","filename":"PivotTableEditorScreenshot2.png","filesize":132139,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditorScreenshot2.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\/pivottableeditorscreenshot2","alt":"","author":"252692","description":"","caption":"","name":"pivottableeditorscreenshot2","status":"inherit","uploaded_to":1790052,"date":"2024-10-18 20:56:01","modified":"2024-10-18 20:56:01","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1001,"height":795,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditorScreenshot2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditorScreenshot2.png","medium-width":329,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditorScreenshot2.png","medium_large-width":768,"medium_large-height":610,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditorScreenshot2.png","large-width":1001,"large-height":795,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditorScreenshot2.png","1536x1536-width":1001,"1536x1536-height":795,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditorScreenshot2.png","2048x2048-width":1001,"2048x2048-height":795,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditorScreenshot2-585x465.png","card_image-width":585,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTableEditorScreenshot2.png","wide_image-width":1001,"wide_image-height":795}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Create ArcGIS for Excel Map using Aggregated Pivot table data<\/strong><\/p>\n

With ArcGIS for Excel, you can create a map that includes data from Excel, ArcGIS Services, and Pivot table. In our Pivot table, the city field in the Rows section is the geographical field that would be used to render data on the map. The fields in the Rows section of the Pivot table would be used as a Location type in ArcGIS for Excel to create a map. The Sum of SALES and Total Customers are aggregated fields in the Values section of the Pivot table. In the dataset, open ArcGIS for Excel task pane, Sign-in to ArcGIS for Excel, and select add layer from the data from the Excel spreadsheet. In the Data drop-down list, the newly created Pivot table would be listed.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2536672,"id":2536672,"title":"PivotTable3","filename":"PivotTable3.png","filesize":116415,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable3.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\/pivottable3","alt":"","author":"252692","description":"","caption":"","name":"pivottable3","status":"inherit","uploaded_to":1790052,"date":"2024-10-18 21:04:51","modified":"2024-10-18 21:04:51","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":802,"height":844,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable3-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable3.png","medium-width":248,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable3.png","medium_large-width":768,"medium_large-height":808,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable3.png","large-width":802,"large-height":844,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable3.png","1536x1536-width":802,"1536x1536-height":844,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable3.png","2048x2048-width":802,"2048x2048-height":844,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable3-442x465.png","card_image-width":442,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable3.png","wide_image-width":802,"wide_image-height":844}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

In the Data drop-down, select Pivot table, and select Address in the Location types drop-down list. And in the Single column tab, select CITY from the Address drop-down list. Then click on Add to map.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2536712,"id":2536712,"title":"PivotTable5","filename":"PivotTable5.png","filesize":82681,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable5.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\/pivottable5","alt":"","author":"252692","description":"","caption":"","name":"pivottable5","status":"inherit","uploaded_to":1790052,"date":"2024-10-18 21:09:56","modified":"2024-10-18 21:09:56","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":663,"height":852,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable5-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable5.png","medium-width":203,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable5.png","medium_large-width":663,"medium_large-height":852,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable5.png","large-width":663,"large-height":852,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable5.png","1536x1536-width":663,"1536x1536-height":852,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable5.png","2048x2048-width":663,"2048x2048-height":852,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable5-362x465.png","card_image-width":362,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable5.png","wide_image-width":663,"wide_image-height":852}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Cities representing the Store location are geocoded on the map. Now we apply the\u00a0Counts and Amounts (size)<\/a>\u00a0smart mapping layer styling to the features using the SALES data attribute. The Counts and Amounts (size) layer styling helps to compare the SALES between the stores. For example, the largest symbols on the map are for Los Angeles and San Francisco stores, suggesting that the highest sales happen at these two store locations.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2536742,"id":2536742,"title":"PivotTable6","filename":"PivotTable6.png","filesize":104329,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable6.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\/pivottable6","alt":"","author":"252692","description":"","caption":"","name":"pivottable6","status":"inherit","uploaded_to":1790052,"date":"2024-10-18 21:12:48","modified":"2024-10-18 21:12:48","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":761,"height":852,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable6-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable6.png","medium-width":233,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable6.png","medium_large-width":761,"medium_large-height":852,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable6.png","large-width":761,"large-height":852,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable6.png","1536x1536-width":761,"1536x1536-height":852,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable6.png","2048x2048-width":761,"2048x2048-height":852,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable6-415x465.png","card_image-width":415,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivotTable6.png","wide_image-width":761,"wide_image-height":852}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

To visualize the Sum of SALES and Total Customers by store location on the map – select the feature on the map, and a pop-up window opens. The pop-up contains descriptive information about the feature, and here the Sum of SALES and Total Customers of the store location is displayed.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2536752,"id":2536752,"title":"PivoTable7","filename":"PivoTable7.png","filesize":78513,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivoTable7.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\/pivotable7","alt":"","author":"252692","description":"","caption":"","name":"pivotable7","status":"inherit","uploaded_to":1790052,"date":"2024-10-18 21:15:18","modified":"2024-10-18 21:15:18","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":737,"height":853,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivoTable7-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivoTable7.png","medium-width":226,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivoTable7.png","medium_large-width":737,"medium_large-height":853,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivoTable7.png","large-width":737,"large-height":853,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivoTable7.png","1536x1536-width":737,"1536x1536-height":853,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivoTable7.png","2048x2048-width":737,"2048x2048-height":853,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivoTable7-402x465.png","card_image-width":402,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/PivoTable7.png","wide_image-width":737,"wide_image-height":853}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

To Summarize \u2026<\/strong><\/p>\n

Microsoft Excel Pivot table is an excellent tool for data aggregation. With the Pivot table, you could also aggregate your duplicate areas data in a way that is easier to analyze \u2013 by average, sum, or count. With ArcGIS for Excel, you can now visualize and analyze the aggregated Pivot table data on a map. To learn more about the ArcGIS for Excel analysis tools, please check the ArcGIS for Excel\u00a0Help<\/a>.<\/p>\n"}],"authors":[{"ID":252692,"user_firstname":"Gaurav","user_lastname":"Singh","nickname":"Gaurav Singh","user_nicename":"gsingh","display_name":"Gaurav Singh","user_email":"gsingh@esri.com","user_url":"","user_registered":"2021-07-16 23:07:37","user_description":"Sr. Product Engineer in the ArcGIS for Microsoft365 group.","user_avatar":""}],"related_articles":"","card_image":false,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Banner-1.png"},"yoast_head":"\nVisualize Aggregated Pivot Table data in ArcGIS for Excel<\/title>\n<meta name=\"description\" content=\"Visualize Pivot table data in ArcGIS for Excel Map.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Visualize Aggregated Pivot Table data in ArcGIS for Excel\" \/>\n<meta property=\"og:description\" content=\"Visualize Pivot table data in ArcGIS for Excel Map.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-18T23:44:56+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\"},\"author\":{\"name\":\"Gaurav Singh\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e581c3c49c1f598179c1ef658d86ec32\"},\"headline\":\"Visualize Aggregated Pivot Table data in ArcGIS for Excel\",\"datePublished\":\"2022-12-08T20:33:44+00:00\",\"dateModified\":\"2024-10-18T23:44:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\"},\"wordCount\":9,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"ArcGIS for Excel\",\"Data Aggregation\",\"Display Pivot table data in ArcGIS for Excel Map\",\"pivot table\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\",\"name\":\"Visualize Aggregated Pivot Table data in ArcGIS for Excel\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2022-12-08T20:33:44+00:00\",\"dateModified\":\"2024-10-18T23:44:56+00:00\",\"description\":\"Visualize Pivot table data in ArcGIS for Excel Map.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Visualize Aggregated Pivot Table data in ArcGIS for Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e581c3c49c1f598179c1ef658d86ec32\",\"name\":\"Gaurav Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Ph3-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Ph3-213x200.jpg\",\"caption\":\"Gaurav Singh\"},\"description\":\"Sr. Product Engineer in the ArcGIS for Microsoft365 group.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/gsingh\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Visualize Aggregated Pivot Table data in ArcGIS for Excel","description":"Visualize Pivot table data in ArcGIS for Excel Map.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map","og_locale":"en_US","og_type":"article","og_title":"Visualize Aggregated Pivot Table data in ArcGIS for Excel","og_description":"Visualize Pivot table data in ArcGIS for Excel Map.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2024-10-18T23:44:56+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map"},"author":{"name":"Gaurav Singh","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e581c3c49c1f598179c1ef658d86ec32"},"headline":"Visualize Aggregated Pivot Table data in ArcGIS for Excel","datePublished":"2022-12-08T20:33:44+00:00","dateModified":"2024-10-18T23:44:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map"},"wordCount":9,"commentCount":0,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["ArcGIS for Excel","Data Aggregation","Display Pivot table data in ArcGIS for Excel Map","pivot table"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map","name":"Visualize Aggregated Pivot Table data in ArcGIS for Excel","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2022-12-08T20:33:44+00:00","dateModified":"2024-10-18T23:44:56+00:00","description":"Visualize Pivot table data in ArcGIS for Excel Map.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/analytics\/pivot-table-data-in-arcgis-for-excel-map#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Visualize Aggregated Pivot Table data in ArcGIS for Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e581c3c49c1f598179c1ef658d86ec32","name":"Gaurav Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Ph3-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Ph3-213x200.jpg","caption":"Gaurav Singh"},"description":"Sr. Product Engineer in the ArcGIS for Microsoft365 group.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/gsingh"}]}},"text_date":"December 8, 2022","author_name":"Gaurav Singh","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/gsingh","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Banner-1.png","primary_product":"ArcGIS for Excel","tag_data":[{"term_id":766102,"name":"ArcGIS for Excel","slug":"arcgis-for-excel","term_group":0,"term_taxonomy_id":766102,"taxonomy":"post_tag","description":"","parent":0,"count":16,"filter":"raw"},{"term_id":768162,"name":"Data Aggregation","slug":"data-aggregation","term_group":0,"term_taxonomy_id":768162,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":768172,"name":"Display Pivot table data in ArcGIS for Excel Map","slug":"display-pivot-table-data-in-arcgis-for-excel-map","term_group":0,"term_taxonomy_id":768172,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":445032,"name":"pivot table","slug":"pivot-table","term_group":0,"term_taxonomy_id":445032,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1329,"filter":"raw"}],"product_data":[{"term_id":766382,"name":"ArcGIS for Excel","slug":"arcgis-for-excel","term_group":0,"term_taxonomy_id":766382,"taxonomy":"product","description":"","parent":36591,"count":21,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-for-excel","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1790052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/252692"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1790052"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1790052\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1790052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1790052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1790052"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1790052"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1790052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}