chart of sales by month and year

Tech_Men
Tech_Men used Ask the Experts™
on
hi there ,
i have this 2 colums in my report :
InvSum
InvDate
the invoice can be from many years
i want to have a chart that i can see the differns from motn by year
for exsample :
04/09 then 04/10 then 04/11 then next month 05/09 05/10 05/11 its depend how mush years involved in the report
i want to see the sum of the invSum col
the line chart need to by month and year from the invDate col
how can i do it ?
thanks ....
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Insert a chart

Choose the Date field for the X-Axis
Set the group to group by MONTH

Choose the sales foeild for the other field in the chart

mlmcc

Author

Commented:
thanks mlmcc for the quick answer but i didint understand what to do
i try to find and do what u suggest but its didint work out for me
can u be a more specific its very importent to me

thanks ..

Author

Commented:
in the chart i want to see the sales by month/year
the goal of the chart is to see the month sales near the period month last year to make an
comparison
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Have been able to create the chart?
Get that created before worrying about filtering the data.

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial