|
The absolute references are there on purpose - If you use a single dollar sign in front of the column reference: $B2, then the column is absolute, but the row can change. It's very useful to have one reference absolute and one relative when making a chart of this nature. The reason that the column C data is screwed up is because the formula is dividing by zero in column C. The formula itself doesn't work.
Do you have any comment on the actual content - the idea behind the chart?
__________________
...Only a few people are awake and they live in a state of constant total amazement. -JP Shanley, Joe vs. the Volcano
|