Looks like you need blue line but not flat portion., You can Control the time so that it does not display flat portion. If you attach a workbook, I can show you how?
Have you tried selecting the data points and then selecting exclude when the hover menu comes up ?
Or as Deepak suggested, attach a workbook.
Hi Deepak ,
I have attached the workbook. I need the Hour to be shown from 7:00 am to 9:00pm as my projections won't change.
But my actuals with update every hour .Current situation as you can see it shows flat line (need to remove that ) . Any inputs are greatly appreciated. Thank you !