Excel 2000 - 3D Bar and Lines

  • Thread starter Thread starter andrrea
  • Start date Start date
A

andrrea

Hi,

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

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

- Jon
 
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/2008/04/10/the-perils-of-being-in-3d/

- Jon
 
Thanks for the great link!!

Jon Peltier said:
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/2008/04/10/the-perils-of-being-in-3d/

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