Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bar Chart with bar data and another bar showing a range of data | Charts and Charting in Excel | |||
Show do I share a dynamic list for data validation? | Excel Discussion (Misc queries) | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
re-selection of Chart data range using keyboard | Excel Worksheet Functions |