Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic updating in chart | Charts and Charting in Excel | |||
Automatic Update of Chart | Charts and Charting in Excel | |||
chart automatic update | Excel Worksheet Functions | |||
automatic scale a chart | Charts and Charting in Excel | |||
Automatic Chart Update? | Charts and Charting in Excel |