3 posts tagged with excel by undercoverhuwaaah.
Displaying 1 through 3 of 3.
I've got three pie charts in excel that show the same cut of information (location of sales) for three time periods: current month, current year YTD, last year YTD, with each chart fed by tables that rank locations by total sales for each time period. I want the color for any given location to be the same in each chart, regardless of its rank for each of the three time periods. How do I do that? [more inside]
[ExcelFilter] Can I use one data validation list drop-down menu to specify which values will show up in a separate data validation list drop-down menu? [more inside]
Is there a way to preserve grand total sorting in an Excel Pivot table when I've got a top 5 value filter on one of the columns? [more inside]