format data series
 

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,

Hi,

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

Cheers
Andy

Jeff wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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" wrote:

Hi,

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

Cheers
Andy

Jeff wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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


Jeff wrote:
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" wrote:


Hi,

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

Cheers
Andy

Jeff wrote:

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, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info