Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
renaming column labels, pivots
Hi,
Could someone pls help me with this. I have "weeks" in my column labels. Sum of 1-Jan-07 Sum of 8-Jan-07 Sum of 15-Jan-07 Sum of 22-Jan-07 As you can see, the lables come up as "sum 01-Jan07". How do I rename several of these lables to show just "01 Jan07" without the "sum" in front of it? I know how to rename single lables, but don't know how to do several at one time. Thanks Kirthana |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
renaming column labels, pivots
Based on what you hvae posted i am assuming that each column is it's own
dimension (field) within the cube. That being the case you can not rename the fields as a group. You could try hiding that row and in an empty row above add your own titles... -- HTH... Jim Thomlinson "KM" wrote: Hi, Could someone pls help me with this. I have "weeks" in my column labels. Sum of 1-Jan-07 Sum of 8-Jan-07 Sum of 15-Jan-07 Sum of 22-Jan-07 As you can see, the lables come up as "sum 01-Jan07". How do I rename several of these lables to show just "01 Jan07" without the "sum" in front of it? I know how to rename single lables, but don't know how to do several at one time. Thanks Kirthana |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
renaming column labels, pivots
thanks.....you just solved my problem......
"Jim Thomlinson" wrote: Based on what you hvae posted i am assuming that each column is it's own dimension (field) within the cube. That being the case you can not rename the fields as a group. You could try hiding that row and in an empty row above add your own titles... -- HTH... Jim Thomlinson "KM" wrote: Hi, Could someone pls help me with this. I have "weeks" in my column labels. Sum of 1-Jan-07 Sum of 8-Jan-07 Sum of 15-Jan-07 Sum of 22-Jan-07 As you can see, the lables come up as "sum 01-Jan07". How do I rename several of these lables to show just "01 Jan07" without the "sum" in front of it? I know how to rename single lables, but don't know how to do several at one time. Thanks Kirthana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do stop Excel changing column widths when doing pivots? | Excel Discussion (Misc queries) | |||
Renaming Column | Excel Worksheet Functions | |||
Renaming Column | Excel Discussion (Misc queries) | |||
Renaming Column | Excel Worksheet Functions | |||
renaming data labels by different cells than source data | Charts and Charting in Excel |