This had us stumped for a while during working on a finance assignment for
university.
We were using a line graph. You can set values for the labels by selecting
one of the lines on the graph and looking to the Formula Bar up top. You'll
see a function with three parameters, except only two are present. The
parameters are ranges. If you find the empty parameter (i.e. the bit between
the commans in something that looks like RANGE(A1:A10),,RANGE(B1:B10) ) then
you can manually input a range of data to use for the x-axis label.
However, this does not apply a continuous data range, unfortunately. It
just uses the source data to get labels. We had a set of data that
represented profit and loss for x number of items sold (a break even
analysis), with the number of items sold incrementing in steps of 10 (e.g. 0,
10, 20, 30, ...) up until 100, where the step changed to 20. Since the chart
only used the source data as discrete text labels, the graph lines took a
sharp upturn after 100, so we had to insert new lines to make sure that the
graph appeared correctly.
Bottom line, that's how you do it, but you can't get continuous data for a
line graph like that (i.e. have the x-axis represent and model a range of
values), just a set of labels that are treated as text.
Microsoft really dropped the ball with Office 2008 for Mac.
Apologies if this is hard to understand, it's 02:30 and I can't get to sleep
Dru
