Using a filtered list as data range for a chart
 

Hello, I would like to chart a cumulative list of numbers I have in one
column (B) on the Y axis and increment the X axis for each Y number i.e. X
runs 1,2,3 etc. By cumulative, I mean the column B rows are derived from
column A eg. B1=A1, B2=A1+A2, B3=A2+A3 etc. The problem I'm having is how to
be able to filter the list of numbers in column B (eg. a subset of numbers
or rows for month) for the Y axis and have the X axis run 1-31 to show a
monthly chart. Ideally, I would like a drop down list to select the month
and have the chart change after a new month is selected. Thanks in advance,
David