How do I reverse the order of a datasheet legend in powerpoint?

[Joe Belmonte]

I have a chart in powerpoint that uses a datasheet. I need to reverse the
order of the legend and the order of how it's displayed on the chart without
actually re-ordering the data in the datasheet. It seems like this should be
relatively simple, but I can't figure it out.

 

[Echo S]

Check the axis options (double-click or righ-click the axis to open the
Format Axis dialog) and see if you have an option for "categories in reverse
order."

 

[Joe Belmonte]

Hey Echo, thanks very much for taking the time to respond. Unfortunately,
that didn't do what I needed. Clicking "categories in reverse order" put the
axis at the top of the chart instead of the bottom, which isn't really what I
wanted. Also, it didn't reverse the order the of data and it didn't reverse
the order of the legend.

In more detail, here's my problem - I have a vertical stacked column chart
with the series in rows. In Column A of the datasheet I have the Average.
The first percentage associate with the average is 30% (cell A1). The second
percentage is 50%.

On the slide the item listed at the top of the legend (when the legend is
displayed to the right of the graph) is Percenatage B and below that is
Percentage A. On the chart, the axis is at the bottom of the page and 30% is
the first percentage which borders the axis. On top of the 30% is 50%.

Basically, I need to reverse the order - I need the 50% to be the first off
of the axis with 30% then on top of it. Also, I need the legend to display
Percentage A on top, and then Percentage B below that.

I realize this is long and complicated, but hopefully someone might know
what I'm talking about. Thanks to anyone who took the time to actually read
this.

 

[Echo S]

Thanks for the details.

I think you're going to have to change the data sheet in order to get what
you want. I could be wrong, and if so, I'm sure one of the Excel MVPs will
be along soon to correct me! Or you may be able to do it in Excel
without too much trouble?

You might be able to fake it using a regular column chart.