Jon:
Again, thanks for your timely repsonse. I'll play with that idea. It's not
perfect only because I'm trying to keep them in order by job number which is
chronological, (we build houses and assign a job number to each one like
5005 (fifth house in 05, etc), but I'll try thinkin' outside the box for a
while. What gets me is I've gotten it right several times, I just have great
difficulty recreating my success. Guess I need to write it down.
Thanks again.
Guy Howe


Jon Peltier wrote:
Guy -

Excel has a particular order in which it orders series.

Probably the easiest way to do what you want is to insert numbers 1 to
50 (or whatever N is) intoa blank column, and sort this column in
descending order before creating the chart. After the chart is created,
with the series in reverse order of the upside down data, sort the
helper column in ascending order, and now the series should jibe with
the sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Jon: Thanks so much for your timely reply. I'll try to be more specific.
The series order of the data in my chart is reversed from the series order of
[quoted text clipped - 30 lines]
it from left to right justified. I need it flipped top to bottom. It
doesn't matter in what order the date is acquired for the chart. Help?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200507/1