Thread: 2007 X Y switching?

I'm trying to "post a workbook".


What I'm supposed to do:

Using the graph paper provided at the end of this manual, create a graph that will be your Hertzsprung-Russell diagram for the Pleiades cluster. Recall that the dimmer a star is, the greater the apparent magnitude number. Bright stars have a small apparent magnitude number; in fact, very bright stars actually have negative apparent magnitudes. Plot your y-axis in such a way that zero magnitude is at the top, and 25th magnitude (a very dim star indeed) is at the bottom. The x-axis should range from -0.4 on the left to 1.8 at the right. Be sure your graph’s y-axis runs from 0 at the top to 25 at the bottom. (CAUTION: creating too small a graph will make it difficult to plot data accurately).

Label the y-axis “m - APPARENT MAGNITUDE”.

3. Plot the calculated B – V data (from step 1 above) on the horizontal x-axis, and Apparent Magnitude (from the V-filter, from column 6 on Table B) on the vertical y-axis using the chart paper.

4. Identify the main sequence of the Hertzsprung-Russell diagram for the Pleiades cluster. Sketch a smooth continuous line through it (do not connect the dots!).

Select the series on the plot and manually edit it to reverse the order of appearance of columns F and G:

=SERIES(Sheet1!$G$2,Sheet1!$G$3:$G$26,Sheet1!$F$3:$F$26,1)

Double-click the Y axis, and on the Scale tab, tick Values in reverse order.