Prev: animated / motion / chart Excel
Next: 2-axis problem with horizontal crossing
From: ultrasounds4u1 on 2 Jul 2008 11:07
I am new to excel. But please have pity and help me. I have a chart that
is perfect but I need to be able to change my pivot table/chart from month to
month to print out reports and it is stuck on giving me the total year info.
Can someone please help. What does my Date need to be labeled as? what
axis? is there a box I am not checking? it will not let me group it? Please
help me? so frustrated..... ;(
--
ultrasounds4u
From: Shane Devenshire on 4 Jul 2008 10:33
Hi,

In the pivot table, right click the word Grand Total and choose Hide from
the shortcut menu. Do this for either the row or column fields or both.

Cheers,
Shane

"ultrasounds4u1" <aaparker(a)netdoor.com> wrote in message
news:50C50F5C-D3DA-4604-B954-616B99B99A71(a)microsoft.com...
> I am new to excel. But please have pity and help me. I have a chart
> that
> is perfect but I need to be able to change my pivot table/chart from month
> to
> month to print out reports and it is stuck on giving me the total year
> info.
> Can someone please help. What does my Date need to be labeled as? what
> axis? is there a box I am not checking? it will not let me group it?
> Please
> help me? so frustrated..... ;(
> --
> ultrasounds4u

 | 
Pages: 1
Prev: animated / motion / chart Excel
Next: 2-axis problem with horizontal crossing