Setting the min value on the x (category) axis to 0, rather than 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Viktor Haag - 14 May 2008 19:51 GMT

I have a large data set of values that has a zero'th value (values
contained in a C-array). 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 (which in itself causes odd values to be
shown for any increment value other than 1, and when your array is
over 300 elements long...).

Can anyone provide a pointer on how to do this with the new version of
Excel?

Thanks!

--
Viktor Haag

Reply to this Message

Viktor Haag - 14 May 2008 20:24 GMT

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

=SERIES( [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.

Reply to this Message

Mac Forum / Applications / Excel / May 2008

Setting the min value on the x (category) axis to 0, rather than 1