Excel 2000 - 3D Bar and Lines
 

Hi,

I am having difficulty creating a chart that has a combo of 3D Bar and
Lines. Only two sets of variables.

Thanks!

Excel 2000 - 3D Bar and Lines
 

It won't work with 3D chart types. Which is okay, because you shouldn't use
3D chart types anyway.

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


"andrrea" wrote in message
...
Hi,

I am having difficulty creating a chart that has a combo of 3D Bar and
Lines. Only two sets of variables.

Thanks!

Excel 2000 - 3D Bar and Lines
 

Thanks for the response!! Why shouldn't I use 3D chart types?

"Jon Peltier" wrote:

It won't work with 3D chart types. Which is okay, because you shouldn't use
3D chart types anyway.

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


"andrrea" wrote in message
...
Hi,

I am having difficulty creating a chart that has a combo of 3D Bar and
Lines. Only two sets of variables.

Thanks!

Excel 2000 - 3D Bar and Lines
 

3D charts are more cluttered, requiring additional shapes to give the false
impression of a third dimension. 3D charts distort data by forcing a third
dimension to be inaccurately portrayed on a 2 dimensional medium. Because of
the third dimensional offset, the data (e.g., the bars) are offset from the
axis ticks representing their values.

Here is a short discussion of these issues:
http://peltiertech.com/WordPress/200...f-being-in-3d/

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


"andrrea" wrote in message
...
Thanks for the response!! Why shouldn't I use 3D chart types?

"Jon Peltier" wrote:

It won't work with 3D chart types. Which is okay, because you shouldn't
use
3D chart types anyway.

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


"andrrea" wrote in message
...
Hi,

I am having difficulty creating a chart that has a combo of 3D Bar and
Lines. Only two sets of variables.

Thanks!

Excel 2000 - 3D Bar and Lines
 

Thanks for the great link!!

"Jon Peltier" wrote:

3D charts are more cluttered, requiring additional shapes to give the false
impression of a third dimension. 3D charts distort data by forcing a third
dimension to be inaccurately portrayed on a 2 dimensional medium. Because of
the third dimensional offset, the data (e.g., the bars) are offset from the
axis ticks representing their values.

Here is a short discussion of these issues:
http://peltiertech.com/WordPress/200...f-being-in-3d/

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


"andrrea" wrote in message
...
Thanks for the response!! Why shouldn't I use 3D chart types?

"Jon Peltier" wrote:

It won't work with 3D chart types. Which is okay, because you shouldn't
use
3D chart types anyway.

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


"andrrea" wrote in message
...
Hi,

I am having difficulty creating a chart that has a combo of 3D Bar and
Lines. Only two sets of variables.

Thanks!