The attached workbook contains a small table (4 columns, 24 rows). It's meant to show monthly unit and sales data for 6 geographic regions. Originally, a slicer was added to allow a user to update a chart to display all regions for a specific month. The chart displays the region as the x-axis, with units and sales on the y and secondary y axes. With me so far? I recently added a second slicer, that would allow the end-user update the chart to just his or her region. But, all the axes remain unchanged, and the x-axis becomes meaningless. I would prefer if the x-axis displayed date labels when that slicer is selected. Or, as a compromise, the region and date, which - honestly - might make for better results when multi-select is used. Any ideas would be greatly appreciated! TYIA
Bookmarks