Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Charts: using a filtered list as a data range
Hello, I have a column of numbers, which I would like to use as the Y axis
on a chart. I can get 5-15 numbers or rows (in the column) each day and I have 8 months of data. I would like to filter the column according time or have a drop down box to select month and change the chart axis to reflect only that month. The X axis only needs to increment for every Y value. If I have another column with incrementing numbers for each row for the X axis, this causes a problem when I want to select only a months data for the chart. Would appreciate any help or ideas. Thanks very much, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Grabbing the filtered data in a list? | Excel Worksheet Functions | |||
Drop down list from filtered data | Excel Discussion (Misc queries) | |||
Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel |