format data series

[Jeff]

Hi,
I have a xy scatter chart in a worksheet. It's a Temperature Vs. Time
chart. Temperatures are gathered using a 3rd party plug (so I can't put any
formula on those cells - since i can't edit an array). Is there a way (using
some kind of formula in format data series) to tell it not to plot anything
below 0 degree, in an other word, leave value on y-axis blank for that day?


Thanks,

 

[Andy Pope]

Hi,

Can you not use additional columns to reference the data gathered by the
3rd party addin, which can contain formula?

Cheers
Andy

 

[Jeff]

Andy,
That would be my last resort. In that case, that means i'll have to
first just the add-in to gather the info, then use vba to copy the entire
range and copy values to some where else. Also, the series are in dynamic
range, that means i'll hv to reset the series every time the worksheet is
updated.

Thanks.

 

[Andy Pope]

If you data feed was into columns A and B could you not have a formula
in C and D that tested the values.

A1: =-1
B1: =2

C1: =IF(A1<0,NA(),A1)
D1: =IF(B1<0,NA(),B1)

You can use named ranges to allow you charts to expand if the number of
rows varies. See here for example.
http://peltiertech.com/Excel/Charts/DynamicCharts.html

If the xy scatter is just markers then you could simply set the minimum
axis value to zero.

Cheers
Andy