View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
cate cate is offline
external usenet poster
 
Posts: 93
Default 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.