Adding a space in a pivot talbe

A

Ash

I'm using a pivot table to get to gross margin.

So I have revenue
- Cost
Margin

I like to be able to have an empty row separating Cost
from Margin so esthetically it would look better.

Anyone knows how to do that? I can't just insert a row,
because I get a message saying you can't do that with a
pivot table.

Thanks
Ash
 
V

Vaughan

I think you should be able to format the Margin row to double height. Would that do?

Otherwise, you can pick up a dummy row for your pivot table (you would have to design it into your source data) and then either re-title it " " or perhaps format the text the same colour as the background, I have spent many a happy hour trying to get formats to "stick" with pivot tables though, so be prepared for some fun and games.
 
W

wiseman

Ash,
How about having another sheet which picks up the pivot table cells i.e.
=Sheet1!A1 in A1 copied to all the cells required. Then you could insert
another column and format etc and print this extra helper sheet. Not
elegant but it may do what you need.
Barbara
 
A

Ash

yea,
Thanks, you're right about spending some long hours trying
to make the formatting to stick. I have tried several
things, like creating dummies etc... but its not really
doing the trick... I'll continue with what you suggested
and see what happens

But thanks for the note :)

-----Original Message-----
I think you should be able to format the Margin row to double height. Would that do?

Otherwise, you can pick up a dummy row for your pivot
Click to expand...
table (you would have to design it into your source data)
and then either re-title it " " or perhaps format the text
the same colour as the background, I have spent many a
happy hour trying to get formats to "stick" with pivot
tables though, so be prepared for some fun and games.
 
A

Ash

Hi Barbara,
This may work, I have to give it a shot. The only thing
that may prove problematic is that I have written vba
codes to refresh the pivot when a selection is made from
that same sheet's controls. So what I could possibly do
is do what you're suggesting but add it to the same
sheet.. further at the bottom....
I think this is a very good suggestion though.

Thanks much
Ash
 
I

icestationzbra

i have office 2002 and it has an option called 'format report'. thi
contains several preconfigured tables and reports. i found that some o
these tables / reports have good layouts, which have features like wha
you are looking for.

this was just an FYI.

mac
 
Top