Series scaling

[Sori]

Hi,
i have a plot with lots of series and each one have a different scale, so i have to multiply or divide by facotr. This fact involves creating a new column for each one. Is there any faster way to do this? What I am trying to do is in the chart creation wizard form to type sonmething like this:
Y-Value =10*(Hoja1!$B$1:$B$16) in order to multiply this range by 10. But of course excel does not accept it.

does anyone help me?

Thanks

 

[Oaktree]

I think you have to set up new columns with your transformations. Or, you could use a secondary axis if your only manipulation is to use either the actual number or 10x the number. From the description you gave though, that does not appear to be the case.

 

[Sori]

thanks for answering,
but what i want to do is not to set up new columns nor to create a sec-axis. Mi problem is that i have a sheet with more than 200 Columns and the file size it starts to be huge. I also have lots of series in a plot in both axis. This is why i will not desire to use those solution.

Regards