I've tried to repro this, and I can't. Show a sample of your original data with real
labels and numbers (just paste into a text response, no attachments). Show also how
your data table looks, by pasting in the values and labels the way they appear in
the chart. Do you have a legend too? List the legend entries as they appear.
Finally, what kind of chart? Bar (horizontal) or Column? Stacked or clustered? What
is the category axis variable? What are the series names? You said the years were
the series, but that doesn't seem to me to be the most relevant way to actually make
your chart.

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

mozermodo wrote:

I'm trying to chart 4 years of data on acceptance rates of 14 colleges. My
data file lists the school names, in alpha order (American, Boston College,
Fordham, Syracuse, etc.) (text format) in column A and the four years of data
(percentage) in columns B-E. The 4 column headers, or data series, are the 4
years, 2002-2005.
The chart looks great, then I added the data table so the data will be on
the page rather than an appendix, and data labels in the chart are too busy.
I used "Chart Options" "Show Data Table". Format Data Table does not seem to
have any options. I have 15 worksheets in my workbook, each with a different
university characteristic and they are all coming out the same. I tried
resorting the data in the data source, and I tried reversing the axis in
"Format Axis", but the chart and the data table flip opposite ways. I even
tried fresh with a whole new workbook and raw data. Does that help clarify? I
appreciate any guidance you can provide. I have to use this in a presentation
and it just looks funny...

"John Mansfield" wrote:


I would first check the formatting of the data to make sure it is formatted
correctly. If there are no data format problems, can you provide an example
of the data that you're trying to chart?

"mozermodo" wrote:


I'm using a simple bar graph with a data table. The data table is in the
opposite order of my graph. I've tried resorting the source data, I've tried
reversing the categories on the axis. I keep getting the same result - the Y
axis is in alpha order from top to bottom (which is what I want) but the data
table is in reverse alpha order (alpha goes right to left)