Re-Ordering Data Sets in Charts

[Stonewall]

I have made a 3-D column chart in Excel with about four sets of data; I have
Series 1-4. Series one is much larger than the others, but since it is a 3-D
graph, it is in front and blocks me from seeing the other data series. I was
wondering if there was a way to re-order the data series so that 1 is in the
back and I could see the other three.

Thanks

 

[David Biddulph]

Select series 1 on the graph. Go to the formula bar, where it may say
something like:
=SERIES(,,Sheet2!$A$1:$A$5,1)
The 1 at the end of the formula gives the order in which the series appear,
so change 1 to 4 and it will go from the front to the back.

 

[Stonewall]

Thanks so Much! That worked Perfectly.

Select series 1 on the graph. Go to the formula bar, where it may say
something like:
=SERIES(,,Sheet2!$A$1:$A$5,1)
The 1 at the end of the formula gives the order in which the series appear,
so change 1 to 4 and it will go from the front to the back.

 

[Jon Peltier]

A far better solution is to change the chart to a 2D clustered column chart.
3D charts are notoriously difficult to interpret correctly.

- Jon