Chart automatic sum
 

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

Chart automatic sum
 

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Execbiz" wrote:

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