Good day all
I am facing the following problem and would like to seek some kind assistance:
It is in worksheet titled "Yield Trend (All Temp) (Scd) (for GM1122)" in attached workbook.
Appreciate all input and help!
-Ms Tan
Hi,
is this what you need?
Ref attached worksheet.
mark as "helpful" and "Answered" if this helps you.
Regards,
Tharanga
Hi Tharanga,
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!
-Ms Tan
hi,
that's possible
check attached work book.
Regards,
Tharanga
Hi Tharanga,
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!
-Ms Tan
Hi,
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.
Regards,
Tharanga
kindly mark as helpful and answered, if this resolved your concerns.
Hi
I wonder why this is still marked as Not Answered?.
Regards,
Tharanga