warning not pro on excel, know way around pretty good. hope can understand me!!
i have made line graph using specific data , able enter of numbers on separate sheet , cell reference line graph. if
ex:
what want enter on sheet 1
pressure | 10 psi |
temperature | -2 deg. f |
what want entry on sheet 1 calculate
what have made
| | temperature deg. f | | |
water content /lbs | -1 | -2 | -3 | -4 |
100 | 10psi | 20psi | 30psi | 40psi |
99 | 50psi | 10psi | 20psi | 30psi |
98 | 60psi | 50psi | 10psi | 20psi |
97 | 70psi | 60psi | 50psi | 10psi |
96 | 80psi | 70psi | 60psi | 50psi |
hi clark,
to better assist you, please share below information better understand situation?
1. second table, please explain how calculate water content/lbs.
2. detailed steps , related screenshots how made line graph using specific data.
3. desired result how enter of numbers on separate sheet.
4. desired result how enter of numbers on cell reference line graph if different question 3's steps.
thanks,
tina
Office / Excel / Windows 10 / Office 365 for business
Comments
Post a Comment