Units Conversion in Charts Source data
 

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

Units Conversion in Charts Source data
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Steve" wrote in message
...
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