Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 18
Default 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
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
sorting 2 colums of numbers and incremening them down blk&wht Excel Discussion (Misc queries) 10 October 9th 06 10:12 PM
Grabbing the filtered data in a list? [email protected] Excel Worksheet Functions 3 August 23rd 06 03:33 AM
Drop down list from filtered data Brady Excel Discussion (Misc queries) 6 June 28th 06 06:47 PM
Using a data validation list to look up a defined named range in another worksheet Laura Hunt Charts and Charting in Excel 0 November 24th 05 03:29 PM
Charts not recognizing source data if original linked data is changed. JLC Charts and Charting in Excel 3 October 14th 05 01:29 AM


All times are GMT +1. The time now is 02:24 PM.

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

About Us

"It's about Microsoft Excel"