Chart automatic sum

  • Thread starter Thread starter Execbiz
  • Start date Start date
E

Execbiz

I have a huge list of invoices in an excel table, and would like to create a
chart that shows the cumulative number of invoices sent by month. What is
the best way to do this? When I create a chart with the "Invoice Sent"
column highlighted, that data becomes the data range, but what I actually
want the data range to be is the row count of invoices sent. Also, when I
try to switch the X and Y axes so that invoice sent date is on the X axis, it
gives an error because there are too many values (max of 255). However,
there should only be a few dozen x-axis values when I'm done, because the
invoices only span a few years.

What is the best way to work around this? I would love to be able to do it
without subtotaling and then charting the subtotal results.

Thanks
 
Hi,

Create a separate range:

Jan
Feb
....

If these are in G1:G12 then in H1 enter

=COUNIF(A1:A1000,G1)

How you actually handle this will depend on what format your dates are
entered in your data range, here A1:A1000.

Then plot G1:H12
 
Back
Top