Units Conversion in Charts Source data

  • Thread starter Thread starter Steve
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Breaking X axis into sub units in a chart 1
Manipulating Data Labels for points on a chart 4
conversion chart 4
Can't drag new data to chart in 2007. 1
Bizarre chart behaviour when changing axis cross at points 2
Labels on data points in chart 1
Duplicating Pivot Chart / Changing Pivot Chart data range 4
Chart Influencing Data 1

Back
Top