| 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 |
| 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 | |||
Threaded Mode
