View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default Chart data reversed.

On Thu, 20 Jul 2006, in microsoft.public.excel.charting,
keeney1228
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 ,
which goes to a spam folder-- please send your email to del3 instead.