Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables and Column Labels
I'm having some trouble creating a pivot table with a large amount of data
that has fields arranged in columns - store, brand, address, supplier a, supplier b etc. When I go to create a pivot table, I select all the data including the titles and get an error telling me I have to create column labels before it will do the pivot table. What's wrong here? Shouldn't it just pick up on the titles as being the fields? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables and Column Labels
Does the source data table have one row of headings?
Is there text in every heading cell? Perhaps there are hidden columns that don't have heading text. Mark McDonough wrote: I'm having some trouble creating a pivot table with a large amount of data that has fields arranged in columns - store, brand, address, supplier a, supplier b etc. When I go to create a pivot table, I select all the data including the titles and get an error telling me I have to create column labels before it will do the pivot table. What's wrong here? Shouldn't it just pick up on the titles as being the fields? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables and Column Labels
Well if that is the cause, I do have hidden columns with no data labels.
Thanks for the advice. "Debra Dalgleish" wrote in message ... Does the source data table have one row of headings? Is there text in every heading cell? Perhaps there are hidden columns that don't have heading text. Mark McDonough wrote: I'm having some trouble creating a pivot table with a large amount of data that has fields arranged in columns - store, brand, address, supplier a, supplier b etc. When I go to create a pivot table, I select all the data including the titles and get an error telling me I have to create column labels before it will do the pivot table. What's wrong here? Shouldn't it just pick up on the titles as being the fields? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel graphs data labels in Pivot tables | Charts and Charting in Excel | |||
Pivot tables, problem with grouping the date column | Excel Discussion (Misc queries) | |||
preserving column width format in excel pivot tables | Excel Discussion (Misc queries) | |||
Column Resizing and Pivot Tables | Excel Discussion (Misc queries) | |||
How do I fix column widths in Excel Pivot Tables? | Excel Discussion (Misc queries) |