Prev: Charts
Next: Totals in the data table but not in the graph / chart
From: cate on 30 Nov 2009 08:21
='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.
From: Jon Peltier on 30 Nov 2009 09:37
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.
From: cate on 30 Nov 2009 10:35
On Nov 30, 8:37 am, Jon Peltier <jo...(a)SPAMpeltiertech.com> 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.
 | 
Pages: 1
Prev: Charts
Next: Totals in the data table but not in the graph / chart