I need to create a pivot table where I just have to display the data not the title of table neither the colum names.. can anyone please help..
to hide the chart name go to properties/title, there you can deselect it.
To hide to formula name, hm, the only thing is maybe to set the colour to white 8or your background colour, but you can't hide them at all.
Changing all labels to ' ' (space) is more reliable than masking with color.
Retrieving data ...