Hey pros, i have seen a post similar to this, but unfortunetly i cant open the files (im on excel 2003), so im unable to find the solution.
My problem is i have a dynamic sheet, where water sampels have been taken on different dates.
the tricky part is that the water samples are being taken from several places, and sometimes they are not taken at the same places.
this means in the dynamic graph im getting lots of dates where no water samples was taken at spot 1. i only want the graph to show dates (xaxis) where samples have actually been taken. and i want it to show the date and not scale by 1year etc.
in the attached file i show the samples in building L1, over several years, as you can see im getting many "blank" dates.
Bookmarks