Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
I am having difficulty creating a chart that has a combo of 3D Bar and Lines. Only two sets of variables. Thanks! |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Warning while inserting lines in Excel 2000 | New Users to Excel | |||
how to print grid lines in bold in excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000: Lines hidden with filter | Excel Discussion (Misc queries) | |||
How do I delete filtered lines in Excel 2000? | Excel Worksheet Functions | |||
Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) |