Created a map chart from table of roofing information with county, state, total squares, brand and style with slicers to drill down into brand and style.
when nothing is selected it is only showing total squares of first value instead of summing all together. When you select slicer of different brand the total squares updates. Not sure what I am doing wrong and I am new to this forum and how to get the pertinent information on here to elicit help. Table layout below
CountyStateSquareBrandStyle
| Sussex | Delaware | 51.66 | CertainTeed | Landmark PRO |
| Sussex | Delaware | 16.00 | TAMKO | Heritage |
| Sussex | New Jersey | 16.08 | CertainTeed | Landmark PRO |
| Sussex | New Jersey | 13.00 | TAMKO | Heritage |
Hi Brett,
Map charts require you to summarise the data into states or countries. You can do this with a PivotTable and then build a regular chart from the PivotTable.
See example file attached.
Mynda
I have the details down to County and state. I believe I have met the limitations of the map chart by trying to add another layer to my slicer. File attached, tab labeled Brand_Map
I appreciate your help. What I am trying to illustrate is without anything selected on the slicer for Brand/Style it will show total squares for the State, County, almost like a sum if statement within the table but I am not sure how to execute that IF it is even possible.
Hi Brett,
The file isn't attached. Please click the yellow 'start upload' button after selecting your file and then wait for the grey check mark beside the file size.
Mynda
