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
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