Though it looks like there is lot of space in the tool tip it doesn't fit the complete sheet and it picks random values in x Axis which represents days of the month. Is there a way to adjust tooltip size. Any suggestions would be a great help
This may help you.
Create Views for Tooltips (Viz in Tooltip)
Also to add to Deepak's suggestion, go to the sheet that you're using as tooltip and set it to "Entire View" or "Fit Width".
Retrieving data ...