Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 7
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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!



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 7
Default 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!




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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!






  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 7
Default 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!








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Warning while inserting lines in Excel 2000 Dave P[_2_] New Users to Excel 1 November 15th 07 10:00 PM
how to print grid lines in bold in excel 2000 jaykay Excel Discussion (Misc queries) 3 August 18th 05 10:27 PM
Excel 2000: Lines hidden with filter Simon Excel Discussion (Misc queries) 4 April 27th 05 03:52 PM
How do I delete filtered lines in Excel 2000? Nicola H Excel Worksheet Functions 1 February 8th 05 03:47 PM
Writing many lines on a same Excel 2000 cell freeposte Excel Discussion (Misc queries) 2 December 8th 04 02:45 PM


All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"