• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Looking for advice

J

jessie

New Member
I have end of the month reports to do on statistics of how many invoices were processed that month for each department. What's the easiest simplest way to do these as far as what kind of chart(s) or something. The numbers are already in an excel spreadsheet. If I leave this department(hopefully)it would have to be something another person could use.


Thank You
 
i would assume that each invoice would be already assigned to its specific department?


if so, you could add a new column that simply places the number 1 for each record. then use this in a pivot table to see how many total invoices each department add.


as far as charts, you could do a column chart or a pie chart.


(i do something like this each week....along with a WHOLE lot more)


are you able to upload a sample?
 
Jessie


Such a limited title description as "Looking for advice" does not really pull the viewing members in.


Turn your data into a table and use sub totals from the Outline section on the Data tab.


You may find this file in my Dropbox of help


https://dl.dropbox.com/u/75495784/The%20Subtotal%20tool%20in%20the%20Outline%20group%20on%20the%20Data%20tab.docx
 
You must log in or register to reply here.
Back
Top