I am trying to get different shares of a blue for my pie chart based on rank.
Colors should be a more darker version of the blue based on their rankings in terms of total cost: so #1 should have lighter version of blue and as the rank increases in terms of total cost, the color should incrememtally get darker.
can this be done in more efficient way other than me typing each rank and color as a seperate line ? if you guys have any ideas it would be highly appreciated. Thanks,
here is what i am planning on using (also attaching a qvw for the example)