Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,180
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Icon Sets - Display icon in one cell depending upon value in anoth Nolene Excel Worksheet Functions 2 February 26th 10 05:43 AM
Referencing Icon Sets BLR Excel Worksheet Functions 3 December 4th 08 03:07 PM
How to collapse Pivot table + icon Yossy Excel Worksheet Functions 1 November 12th 08 02:54 PM
Additional Icon Sets Kevin S Excel Discussion (Misc queries) 0 July 3rd 07 03:18 PM
How do I create a pivot table if the pivot table icon or menu ite. Lynn@WS Charts and Charting in Excel 1 December 16th 04 02:36 AM


All times are GMT +1. The time now is 06:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"