Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use icon sets relatively in a pivot table
Hi All!
I can use icon sets for certain things, but am unable to figure out how to use them with my existing data. I have a pivot table that may list sales from Quarter 4. If you expand that level of the pivot table you would see the monthly, weekly and daily sales that constituted Quarter 4. But I want to show icons to give a visual cue if Q4 was up from Q3. I would need to do this again in the future to see if Q1 is up from the previous years Q4. Sample Data would be: Week Sales (want to see icons in this column, beside numbers) 4 20 3 15 I want to know at a glance if the 20 is higher than the 15; Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use icon sets relatively in a pivot table
Excel 2007 PivotTable
Arrow Icons Change from previous value. http://c0718892.cdn.cloudfiles.racks...03_29_10a.xlsx Pdf preview: http://www.mediafire.com/file/x1h5jqnyjwy/03_29_10a.pdf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Icon Sets - Display icon in one cell depending upon value in anoth | Excel Worksheet Functions | |||
Referencing Icon Sets | Excel Worksheet Functions | |||
How to collapse Pivot table + icon | Excel Worksheet Functions | |||
Additional Icon Sets | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |