Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
changing from days to months
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
changing from days to months
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
First and last days in months | Excel Discussion (Misc queries) | |||
i have two days and i want the difference in days, months, year | Excel Worksheet Functions | |||
convert Days to Years, Months, Days | Excel Discussion (Misc queries) | |||
not all months have 31 days | Charts and Charting in Excel |