3 posts tagged with excel by undercoverhuwaaah.
Displaying 1 through 3 of 3.

Excel Chart Coloring Issues

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]
posted by undercoverhuwaaah on Jul 17, 2013 - 1 answer

Validating data for data validation.

[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]
posted by undercoverhuwaaah on Aug 15, 2012 - 2 answers

Preserving grand total sorting with a value filter in place.

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]
posted by undercoverhuwaaah on Sep 3, 2010 - 1 answer

Page: 1