Charting Filtered Data

  • Thread starter Thread starter BCullenward
  • Start date Start date
B

BCullenward

I have an excel sheet that has a bunch of data imported to it from SQL
Server 2k. I need to either pull all the relevant data from a date
typed in by the user which that data returned will be used to build my
charts,
or
find a way to build the chart from filtered data where the entire table
is imported, but the user selects the data to filter on. (this idea is
probably not a good idea as the table is already at 11k records and
grows by roughly 20 records a day).
 
To show only filtered data, select the chart, then Tools | Options... |
Chart tab | Active chart section | select the 'Plot visible data only'
checkbox.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 
Back
Top