|Stacked Bar Chart in 2.5.2 -- need to set series visibility based on other data column value [message #876655]
||Fri, 25 May 2012 03:30
| Tom Yamada
Registered: July 2009
Stacked Bar Chart
I am working off a flat dataset where the chart will only display selected columns as series as specified by a field on the row. The displayed columns also need to have their series titles changed to values held in other columns corresponding to each series.
Data is of this nature:
CAT DISPTO COL_01 COL_02 COL_03 COL_04 LAB_01 LAB_02 LAB_03 LAB_04
AA 3 40 30 50 0 S_01 S_02 S_03 S_04
BB 3 25 65 5 0 S_01 S_02 S_03 S_04
CC 3 9 19 29 0 S_01 S_02 S_03 S_04
I have set up a stacked bar chart with series for each of the four columns and dummy titles. When the design is run the chart needs to show only the first DISPTO number of columns, so with the example data the chart would show series for COL_01, COL_02, and COL_03 while the series corresponding to COL_04 would need to be suppressed in both the plot area as well as the legend. The series that are displayed will need to use their corresponding LAB_0x column values in the legend.
This has had me going a bit in circles so I would appreciate if some kind soul could help me get headed in the correct direction. Thanks!