October 17, 2018
It is my first time using a Map chart. I have data in a table and I was hoping that the Map chart would be able to sum the data from the table and insert total into the chart. For example the Marshall county total sales is 1104.7, but the chart only picks up the first record of 14.8144.
Is this the way it is supposed to work?
I was initially excited and thought that I could have some slicers on this chart for Counties, salesmen, periods, or states. But now it seems this chart can't do that.
Is it best to just use totals before I chart it? Perhaps I could sum up the counties first and then chart the totals, but that feels limited. Am I asking to much from this chart?
Thanks for any insight
July 16, 2010
Correct, you must aggregate the data by county for Map charts, but they aren't compatible with PivotTables. However, you can do this with a PivotTable and then trick the map chart into referencing the PivotTable, as explained here: How to build regular charts from PivotTables.
This way you can still use Slicers to filter the data.