Re: x-axis in Excel 2008

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
:P

Dru

"mattebury@xxxxxxxxxxxxxxxx" wrote:

I'll try again with this question. Anybody know how to change the values Excel 2008 uses for the x-axis?

.

Relevant Pages

  • RE: Aligning tick marks and labels on line charts or scatter charts
    ... Select Graph wizard, select scatter plot, select next, select next, select ... Value axis Crosses at: 0.5. ... The range is correct, and the labels are ... On tick marks", ...
    (microsoft.public.excel)
  • Re: How to plot Double values graph with MSChART
    ... "The MSChart control provides a ChartData property for loading data ... directly from an array into the data grid. ... 'Set the column labels. ... Code for Drawing Graph ...
    (microsoft.public.vb.general.discussion)
  • Re: Negative #s on the wrong side
    ... Excel is like that. ... I already tried every alignment option Graph ... >> gigantic to fit all the data labels on the end, ...
    (microsoft.public.excel.charting)
  • Re: Bug on Graphs
    ... That means it's probably not a problem with PowerPoint specifically, but probably something unique to your system. ... I click the graph icon in the second box (which opens the "insert graph") ... was already opened), lose randomly, axis labels, Data labels and even the ...
    (microsoft.public.powerpoint)
  • Re: adding titles to data
    ... assign a thirid data-set for the labels and speed things up. ... scatter-graph and for each point on the graph, we wanted the name of the ... Dave ... I don't think there's a way that you can make Excel pull the names ...
    (microsoft.public.excel.misc)