Rearrange Chart Catagories w/o changing Table

  • Thread starter Thread starter zgendron
  • Start date Start date
Z

zgendron

Hi All,

I have data that I wish to present as both a table and a chart.

I am wondering if there is a way to rearrange the order of the X-Axis
(Catagory) data without rearranging the actual table.

I am able to rearrange the series order, but cannot seem to rearrange
the Catagories.

I am using Excel 2000, and this is not a PivotTable.

Thanks in Advance,
Zack
 
Is it a data table in the chart? I don't think so, because otherwise the
categories would already line up.

You could make your chart based on a dummy data range, which in turn is
linked by formulas to the data table you want to display.

- Jon
 
Back
Top