Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Charts While Changing Source Data | Charts and Charting in Excel | |||
Editing Source Data in Charts | Charts and Charting in Excel | |||
Setting source data range with Charts | Charts and Charting in Excel | |||
extending source data in several charts | Charts and Charting in Excel | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel |