Chart data reversed.

K

keeney1228

I have created a Stacked Bar chart, and rigged it so that it looks lik
a gantt chart. My problem is that the information is reversed accordin
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! Thank
in advance
 
D

Del Cotter

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top