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/
_______
Guy H via OfficeKB.com wrote:
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
the data on the spread sheet. So the older jobs, nearer the top of the
spreadsheet, and naturally closer to completion, have higer percentage
numbers. The opposite holds true for newer jobs. When I insert the chart to
reflect those percentages (to make it easy for the big boss to look at ) the
chart appears 'upside down' as it relates to the series order. If it was
only 3 or 4 items I could change the series order using the function
available, but its 50 or so, and I just know I'm missing something or doing
something wrong to make that graph keep coming in 'upside down'. OK?
To complicate it, I place that chart adjacent to the spreadsheet numbers so
each 'bar' on the bar chart lines up with each corresponding row on the
spreadsheet - for a nice graphic effect, but I do have trouble getting the
font sizes right without some work).
Jon Peltier wrote:
Your problem isn't too clear. Do you need the percentages plotted on a
secondary Y axis? Double click the series, and on the Axis tab, select
Secondary.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
I use a spreadsheet that shows the 'percentage of completion' for about 50
items, each on a different row, with 5 columns of data (other 4 colums being
[quoted text clipped - 6 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?