D
DavidS
Hello, I would like to chart a filtered 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 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. 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
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 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. 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