| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Pivot 2007 Report Format
I am trying to format pivot to better display of an Event Timeline. I have one Pivot by Category, Sub-catetory, etc. and the other Pivot by Date, Tim, Categ, SubCateg. My Event Committee are reading the blank indents as "missing" informatiion. The Design color options do not help. I have also tried the Setting the Field Options for the Columns to indent. eg. Category Sub-catg Date Action Budget Budget 20-Feb Set up budget tracking report Committee Auction Gifts 20-Feb Coordinate sales of ads/gifts 6-Mar Coordinate with Allison CommitteeRoles 6-Mar Pull more volunteers, target Organizer 20-Feb Quick review of Committee Roles Looking to do something like this: Category Date Action Budget Budget 20-Feb Set up budget tracking report Committee Auction Gifts 20-Feb Coordinate sales of ads/gifts Auction Gifts 6-Mar Coordinate with Allison CommitteeRoles 6-Mar Pull more volunteers, target Organizer 20-Feb Quick review of Committee Roles -- Susan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Pivot 2007 Report Format
Hi,
I'm not clear on what your problem is. However, maybe changing the Report Layout will solve your problem. With the pivot table selected choose PivotTable Tools, Design, Report Layout and try all three options. Just a note - you can modify the color style of your pivot table, and you can always apply manual formatting on top of the pivot table style. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Susan" wrote: I am trying to format pivot to better display of an Event Timeline. I have one Pivot by Category, Sub-catetory, etc. and the other Pivot by Date, Tim, Categ, SubCateg. My Event Committee are reading the blank indents as "missing" informatiion. The Design color options do not help. I have also tried the Setting the Field Options for the Columns to indent. eg. Category Sub-catg Date Action Budget Budget 20-Feb Set up budget tracking report Committee Auction Gifts 20-Feb Coordinate sales of ads/gifts 6-Mar Coordinate with Allison CommitteeRoles 6-Mar Pull more volunteers, target Organizer 20-Feb Quick review of Committee Roles Looking to do something like this: Category Date Action Budget Budget 20-Feb Set up budget tracking report Committee Auction Gifts 20-Feb Coordinate sales of ads/gifts Auction Gifts 6-Mar Coordinate with Allison CommitteeRoles 6-Mar Pull more volunteers, target Organizer 20-Feb Quick review of Committee Roles -- Susan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Pivot 2007 Report Format
Excel 2007
Pivot Table with dynamic conditional formatting: http://www.mediafire.com/file/jhuxgndkiie/02_21_09.xlsx |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Pivot 2007 Report Format
Hi,
if you want to send me a sample of the pivot table my email is my name as below (without a space) @sbcglobal.net -- If this helps, please click the Yes button Cheers, Shane Devenshire "Susan" wrote: I am trying to format pivot to better display of an Event Timeline. I have one Pivot by Category, Sub-catetory, etc. and the other Pivot by Date, Tim, Categ, SubCateg. My Event Committee are reading the blank indents as "missing" informatiion. The Design color options do not help. I have also tried the Setting the Field Options for the Columns to indent. eg. Category Sub-catg Date Action Budget Budget 20-Feb Set up budget tracking report Committee Auction Gifts 20-Feb Coordinate sales of ads/gifts 6-Mar Coordinate with Allison CommitteeRoles 6-Mar Pull more volunteers, target Organizer 20-Feb Quick review of Committee Roles Looking to do something like this: Category Date Action Budget Budget 20-Feb Set up budget tracking report Committee Auction Gifts 20-Feb Coordinate sales of ads/gifts Auction Gifts 6-Mar Coordinate with Allison CommitteeRoles 6-Mar Pull more volunteers, target Organizer 20-Feb Quick review of Committee Roles -- Susan |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Pivot 2007 Report Format
Click at Pivot Table. Go to last menu on the right side. (I guess, it's
called design), click on layout (left hand side section), click on 3rd button from left (layout) and choose display in compact form. "Susan" wrote: I am trying to format pivot to better display of an Event Timeline. I have one Pivot by Category, Sub-catetory, etc. and the other Pivot by Date, Tim, Categ, SubCateg. My Event Committee are reading the blank indents as "missing" informatiion. The Design color options do not help. I have also tried the Setting the Field Options for the Columns to indent. eg. Category Sub-catg Date Action Budget Budget 20-Feb Set up budget tracking report Committee Auction Gifts 20-Feb Coordinate sales of ads/gifts 6-Mar Coordinate with Allison CommitteeRoles 6-Mar Pull more volunteers, target Organizer 20-Feb Quick review of Committee Roles Looking to do something like this: Category Date Action Budget Budget 20-Feb Set up budget tracking report Committee Auction Gifts 20-Feb Coordinate sales of ads/gifts Auction Gifts 6-Mar Coordinate with Allison CommitteeRoles 6-Mar Pull more volunteers, target Organizer 20-Feb Quick review of Committee Roles -- Susan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report Format - Pivot Table not working | Excel Discussion (Misc queries) | |||
| pivot table report not valid when opening xls created in 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 Pivot table's Report filter fields value sorting | New Users to Excel | |||
| Pivot tables - Format Report | Excel Discussion (Misc queries) | |||
| Pivot tables - Format Report | Excel Discussion (Misc queries) | |||
Hybrid Mode
