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