Re-Ordering Data Sets in Charts
 

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

Re-Ordering Data Sets in Charts
 

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.
--
David Biddulph

"Stonewall" wrote in message
...
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

Re-Ordering Data Sets in Charts
 

Thanks so Much! That worked Perfectly.

"David Biddulph" wrote:

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.
--
David Biddulph

"Stonewall" wrote in message
...
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

Re-Ordering Data Sets in Charts
 

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

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


"Stonewall" wrote in message
...
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