Chart data reversed.

I have created a Stacked Bar chart, and rigged it so that it looks like a gantt chart. My problem is that the information is reversed according to how the data is listed. If I have jobs 1-20 listed under column A, the jobs are listed 20-1 in the chart. We're new at this chart thing, so let us know if it's something easy we're just not catching! Thanks in advance.

On Thu, 20 Jul 2006, in microsoft.public.excel.charting,
keeney1228 <[email protected]>
said:

>I have created a Stacked Bar chart, and rigged it so that it looks like
>a gantt chart. My problem is that the information is reversed according
to how the data is listed. If I have jobs 1-20 listed under column A,
>the jobs are listed 20-1 in the chart.

There's a check box in the Format Axis dialogue box that says "Values in
Reverse Order". Tick that, and your jobs will be listed 1-20 reading
down the chart instead of up.

--
Del Cotter
NB Personal replies to this post will send email to [email protected],
which goes to a spam folder-- please send your email to del3 instead.