Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple Charts That React to Custom Excel Filters?
Fellow Forum Members,
Not sure if this is the is the proper subforum to post in or if my Keyword title is adequate, maybe the forum admin could address these concerns. I'm using Excel 2007 and my objective is to setup a trading log that tracks my performance with charts that dynamically update to applied custom date range filters. The link below shows screenshots of what I'm trying to emulate with Excel 2007. http://www.fxtraderlog.com/screenshots.htm I have all my trading data laid out in a tabular format simlar to what is shown in the top screenshot. My tabular layout differs in that it includes 4 additional columns. My chronological data layout I'm using seems to be troublesome for conventional Excel charting methods. When I apply custom filters for open dates and close dates, my Excel charts do not dynamically react. What I have determined is that I need to bypass the conventional charting methods used in Excel and focus instead on using Charts that rely on a VBA script or a formula. My objective is to have multiple charts (like the ones shown in the screenshots link above) all using the same data nested in my tabular trading log. Can anyone out there help me out with setting up Charts that are more robust? I would appreciate example VBA scripts and / or links that will show me how to setup charts that dynamically react to custom Excel Filters, and can group together matching data sets in a column and show such data sets as a single slice in a pie chart. Currently, I'm getting multiple pie slices for the same data set. I need a formula or a VBA script that will clump together all of the data that belongs in the same group and show it as a single slice in a pie chart. Any help that will help me get past these two hurdles will be greatly appreicated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL FILTERS AND CHARTS | Excel Discussion (Misc queries) | |||
custom chart - variable axis - multiple charts | Charts and Charting in Excel | |||
Custom filters | Excel Discussion (Misc queries) | |||
Named custom filters? | Excel Discussion (Misc queries) | |||
troubleshoot custom Excel Auto Filters when the column is a # or d | Excel Worksheet Functions |