Displaying remarks for particularly selected date and equipment in another sheet

[Dheeraj0501]

Hi all,

I have a pivot table data containing truck numbers and their trips per day. This is data is displayed as performance bar graph in next sheet for particular date selection range(start and end date between which trips are counted).
Now I would like to add remarks column in pivot data.
Please suggest some way to display this remark near graph on selection of truck number and date.( like trips 0 -- breakdown,3 -- raining etc....remarks also vary because large numbers of users)

Thanks in advance

Regards
Dheeraj

 

[bobhc]

Good day and welcome to the forum
An actual file upload would help.

 

[Dheeraj0501]

Please find the actual file...

 

[bobhc]

Where is your data sheet?

 

[Dheeraj0501]

Unable to attach since file size is too large...error pop up during upload..

 

[bobhc]

You can use Dropbox, it is free with no adds, open an account upload and then post the link here.
Or copy the sheet and strip down the data and then upload.