Showing results for 
Search instead for 
Did you mean: 

Xcelsius - Combo box - missing line

Former Member
0 Kudos

I have a problem with a document that tracks progress of actions over a number of weeks.

There are 3 combo boxes that are used as filters:

Filter 1:  A or B

Filter 2: ABC or XYZ or ABC+XYZ

Filter 3: Priority 1-7

Combo box 1 filters on A or B and pastes the data in an empty field (marked yellow in the file)

Combo box 2 takes the data from the field of Box1 and filters on ABC/XYZ/Both, then pastes it in another empty area.

Combo box 3 takes the data from the field of Box 2 and filters on Priorities 1-7, then pastes the data in 3 empty rows.

The filtered data is displayed in a graph with 3 lines: Planned, Executed, Passed; the data is sourced from the 3 rows that Box 3 uses as destination.

The filters and graphing works perfectly for Priorities 1-6, but when selecting Priority 7 only 2 lines are displayed (Planned&Executed), and Passed is dropped for an unknown reason. I double checked the Source and Destination fields of all combo boxes and can't find any fault, but there must be one that makes it that the last line is dropped. Could someone help find it?

I can't attach the XLF file here so I've uploaded it here:

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos


You have done a small selection mistake. In third combo box(priority)

lables (P81 to p103);

But it should be P81 to P104;

it has resolved the issue. check it now.



Former Member
0 Kudos

Oh, I was so focused on the Destination and Source boxes that I completely missed that. Thank you for your help!

Answers (0)