James maverick
New Member
- Joined
- Jun 25, 2010
- Messages
- 9
Hello everyone,
Good day, I'm trying to come up with a graph based on a pivot table, one of the issues i am having is with the dates.
on column a i have the dates as per normal:
1/09/2009
2/09/2009
3/09/2009 and so on and so forth
i have then formated the dates to show MM-YY
Sep - 09
Sep -09
Sep 09
Problem is, with the pivot table it still is broken down per day, so for example i have got three rows of Sep - 09, when all i want is i row for that month, and another row for another month...so the graph would be monthly and not daily.
help please
regards,
James
Good day, I'm trying to come up with a graph based on a pivot table, one of the issues i am having is with the dates.
on column a i have the dates as per normal:
1/09/2009
2/09/2009
3/09/2009 and so on and so forth
i have then formated the dates to show MM-YY
Sep - 09
Sep -09
Sep 09
Problem is, with the pivot table it still is broken down per day, so for example i have got three rows of Sep - 09, when all i want is i row for that month, and another row for another month...so the graph would be monthly and not daily.
help please
regards,
James