Forum Discussion
houston1940
Apr 05, 2025Copper Contributor
Excel Chart Help
Not sure how to accomplish what I am looking to do... I want take the attached (see Dropbox link below) workbook, and create charts for the different types of police calls. And filter by date. Two ch...
houston1940
Apr 08, 2025Copper Contributor
This is amazing! You're the best! One question... sheet 1 has the grand total as 339 calls, which is accurate, but on sheet 2 the grand total is only 179. How can I make them match?
HansVogelaar
Apr 08, 2025MVP
I made the pivot table and chart on Sheet2 display only the top 10 items.
Click the drop-down arrow of the Row Labels cell and select 'Clear Filter from Title1".
You'll see all items then.