Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello --
This charting application has the following features: 1 - user can "import" a time series (into a set of columns in a worksheet); the app automatically adds a plot of the data to the chart 2 - user can delete from the chart a series which was plotted in 1; the source data is not deleted from the worksheet which holds it 3 - user can decide later to add to the chart a series deleted in 2 Problem: I want to present in a listbox the names/legends of the "imported but not plotted" series so the user can select one for 3 If I could use SQL in this app, the source for the listbox would look something like: SELECT name_Imported FROM tblImported WHERE name_Imported NOT IN (SELECT name_Plotted FROM tblPlotted) Example: Imported Plotted ------------ ---------- series1 series1 series2 series4 series3 series4 series5 The listpox would contain the values: series2 series3 series5 Each "tbl..." would, I assume, be a range in one of the application's worksheets, and filled by a process I don't know how to code. Can anyone suggest how to populate such a listbox? Thanks for any help. Larry Mehl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need chart of 1 data set plotted against another similar data set | Charts and Charting in Excel | |||
Extra data plotted on chart | Charts and Charting in Excel | |||
Filter the way data is plotted | Charts and Charting in Excel | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel |