On May 14, 2:51=A0pm, Viktor Haag <veh...@[EMAIL PROTECTED]
> wrote:
> In previous versions of Excel, I seem to
> remember being able to set the x-axis numeric values to start at 0,
> and incrememt every so-and-so much. Now, with Excel 2008, I can't seem
> to figure out a way to start the numeric values starting on the x-axis
> at any value other than 1
To answer my own question, and for the help of others, it helps to
know the syntax of the SERIES function used to build a chart:
=3DSERIES( [Name] , [X Values] , [Y Values] , [Plot Order] )
Excel seems to build bar charts with empty category value ranges
(either X or Y, depending on chart orientation). If you have a range
of associated category label values that goes along with your actual
series data values, then you can specify that range as well as the
value range, and the Axis values get populated appropriately.
--
V.
|
