Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 18
Default Using a filtered list as data range for a chart

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bar Chart with bar data and another bar showing a range of data DQuint Charts and Charting in Excel 2 September 7th 06 04:44 PM
Show do I share a dynamic list for data validation? KarenF Excel Discussion (Misc queries) 16 August 1st 06 10:51 PM
Charting data points and show a target range on the same chart. Minireefkeeper Charts and Charting in Excel 6 February 18th 06 06:50 PM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
re-selection of Chart data range using keyboard David Excel Worksheet Functions 0 June 15th 05 10:08 AM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"