Thank you for your input!
I would like to have
1) Bar Graph for Lot Id 4000841 to be red (because it has scd 3354)
2) Bar Graph for Lot Id 5000842 and 6015378 to be orange (because they have the same scd 9789)
3) Line Graph (the dot) for Lot Id 4000841 to be green (because it has scd 3354)
4) Line Graph for Lot Id 5000842 and 6015378 to be blue (because they have the same scd 9789)
Is it possible? Really appreciate your time and help!
Thank you for your time and help!
So sorry, do you know of a way that does not require us to specify (i.e. hardcode) the values?
e.g. don't specify Lot Id = 4000841.
Because the live data that I am given will continuously update with more Lot Ids, and more scds (i.e. not just scd 3354 and 9789). Would like different colors for different scds.
Really appreciate all your time and help in this!
1 of 1 people found this helpful
Yes you can simply add "Lot ID" into Color card and adjust the color accordingly.
But on your chart, since you have a combo chart which will have only one particular color set for both graphs.
kindly mark as helpful and answered, if this resolved your concerns.
I wonder why this is still marked as Not Answered?.