Refrencing data from a line graph on Excel - Microsoft Community


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

water content/lbs 99 lbs

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

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

Activation Error 0x8004FE93 - Microsoft Community