I have an concern regarding color codes in a bar chart with a cyclic drill down option.
I have two dimensions and defined with two sets of color codes for each,On flip option the same should reflect ,but since it is a flip and two set of colors are not implemented together.
Is their any options to implement my requirements.
Please find the attached source n QVW.
Thanks In advance.
I have gone through the article which you have shared, but I'm not sure how it works for my requirements( i.e two different set of colors for a dimensions grouped in a cyclic flip option)
Thank you .
As suggested in the attachment ,I have to create a color code via excel or inline.
But I dnt want to use the color code in script as I have many variations in the color code , also I Used a expression to sort in a order.
Can you please suggest some other alternative.I have tried using defined color codes but due to persistent option it is changing .
Please find the attracted qvw.
This is the script I used
(ooxml, embedded labels, table is Sheet1);
(ooxml, embedded labels, table is Sheet2);
(ooxml, embedded labels, table is Sheet3);
The script in red are getting picked from the Excel file....not sure why you think they are defined in the script?