Units Conversion in Charts Source data

S

Steve

I need to have two charts in different units (1 in oz/ft2 and 1 in gm/m2). I
was wondering if I could put the coversion factor in the chart souce data and
avoid adding a new column of converted data to the worksheet? In case 1 the
formula would be as shown below while the data would have to be multiplied by
305 for the second chart.

='Graph Data'!$Z$2:$Z$44

Thanks Steve
 
B

Bernard Liengme

No, the data to be charted must be in cells
Not sure why you are worried about the extra column: it could be far off to
the right out of sight or it could be hidden.

Hint: if you want labels to read oz/ft² with a nice superscript, hold down
ALT and type 0178 on the numeric keypad (not the numbers on top row of
regular keys)

best wishes
 
Top