Let's work on making sure you are seeing the correct values on the channels first. The workbook and gauge is just the pretty way to view them in a nice dashboard but if the channel values aren't right it's always going to be wrong on the gauge.
I think your calibration might be out, based on your earlier photos the 24mv will be 2.4 degrees when it should be 24 degrees.
All calibrate > temperature > cylinder 1
Set the calibration to CAN 0DP.1.0
Does Cylinder 1 channel value now show the expected temp in degrees?
If thats all good move on to your workbook gauges, As for "best method to view" I personally view EGT's on a time graph. screen shot attached with some options but the way you have been doing it is correct. Not sure why the temp sensor was blank id have expected it to show 2.4 degrees.