Auld Nick II
Aug 29th, 2003, 10:29 AM
Hi,
I'm trying to produce a chart in MS Access, that will, in the most, produce bars representing values of 1 or 2. The highest point on the Y axis is 100. Very occaisionally a rogue observation comes about, where the value will be 300+. Obviously this will dissapear off the top of my chart, but without giving any indication of what the value is (other than that it is 100+). I don't want to use data labels on every occaision, becuase this will look to cluttered.
Does anyone know a way that I can apply a data label to just those values over 100?
Many Thanks,
AuldNick:)
I'm trying to produce a chart in MS Access, that will, in the most, produce bars representing values of 1 or 2. The highest point on the Y axis is 100. Very occaisionally a rogue observation comes about, where the value will be 300+. Obviously this will dissapear off the top of my chart, but without giving any indication of what the value is (other than that it is 100+). I don't want to use data labels on every occaision, becuase this will look to cluttered.
Does anyone know a way that I can apply a data label to just those values over 100?
Many Thanks,
AuldNick:)