Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use horizontal lookup with pivot table
hello,
I set up a graph that contains one series from a given range and two series from a pivot table. The data is filtered by the pivot table by month (1 to 12) and by type (Development/Infrastructure). If there is nothing in a given moth you end up with less than 12 points to plot for a given year. To plot this I use another range using hlookup to have the data in the corresponding month of the year. The problem comes when I need to update the pivot table. The range used in the hlookup formula has to be updated asweel and I don't know if there is something to tell hlookup that the array is the pivot table and not a fixed range. Any help will be greatly appreciated. Thank you, regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LookUp on a Pivot table | Excel Worksheet Functions | |||
creating pivot from a horizontal table | Excel Worksheet Functions | |||
Lookup within Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Can I use a 'lookup' to a Pivot Table? | Excel Discussion (Misc queries) |