BIOL 340  Take the line means and standard errors that you calculated last week (posted as “line_treat_se_plot”) and make the following figure

BIOL 340 
Take the line means and standard errors that you calculated last week (posted as “line_treat_se_plot”) and make the following figure. It should look EXACTLY like this figure I am not giving you much to go on here (on purpose). I strongly encourage you to use Excel because then we can help. Here are some hints for the trickier things. 
• I would format the data to be in the following columns: 
LINE, LOW SUGAR MEAN, HIGH SUGAR MEAN, LOW SUGAR SE, HIGH SUGAR SE 
• You will need to sort the data based on low sugar mean but make sure all the columns get sorted • I started with a 2D line chart, added and modified the markers and deleted the lines. • You will need to add custom error bars 

Percental of flies alive at day 8 
1.4 
1.2 
1 
0.8 
0.6 
0.4 
0.2 
0 
-0.2 
-0.4 
Mean Female Survival Rank Ordered based on low sugar High Sugar Low Sugar 
LINE