scale a single series (divide each datapoint by X)
 

='sheet1'!$BT$63:$CA$63

I have single series in a group that has large values compared to the
others contained in the same chart. I would like to scale this single
series; divide each point by 10. Was looking for an array function to
do this but couldn't figure it out.

Thank you.

scale a single series (divide each datapoint by X)
 

Insert a row, use formulas in the inserted row to compute the new
values, and chart the inserted row.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



cate wrote:
='sheet1'!$BT$63:$CA$63

I have single series in a group that has large values compared to the
others contained in the same chart. I would like to scale this single
series; divide each point by 10. Was looking for an array function to
do this but couldn't figure it out.

Thank you.

scale a single series (divide each datapoint by X)
 

On Nov 30, 8:37*am, Jon Peltier wrote:
Insert a row, use formulas in the inserted row to compute the new
values, and chart the inserted row.

I thought that might be required. Thank you Jon.