Plot data beyond the maximum as the maximum

[rodrignj]

Hello all,

I have a set of graphs that I generate automatically, that I need to adjust slightly. My Y Axis goes from 0 - 1000 but I have some values outside of this range. For those values that occur beyond 1000 I would like to plot a point at 1000 to alert the user to the fact that the data exists.

A desired features: if it would be at all possible to change the format of an individual data point based on a cell value (ie a cell value greater than 1000) that would be fantastic; this isn't necessary but it would make reviewing the data (nearly 100 charts) even easier.

thanks!

[Melvinrobb]

I would suggest adding a column to your data that only displays a value of 1000 if the original value is over 1000. you then can format that data set as being a different colour.

[rodrignj]

I was thinking that, I was just hoping for something a little more elegant.

thanks.