Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
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 | |||
auto updating list | Excel Worksheet Functions | |||
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) | |||
Conditional data validation (using a filtered range?) | Excel Worksheet Functions |