Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 39
Default Excel 3-D Pie Chart Flaw & Test

I believe there is a flaw with the boarders on 3-D pie charts in Excel 2007.
Try to enter some data - say 6 names with unequal percentages that sum to
100%. If you chart this data using a 3-D pie chart and give the pie itself
and the pieces of pie black boarders the boarders are very jagged. These
jagged boarders are easy to see in a zoom view or if you print the pie chart
out. Thank you in advance to anyone who can test this in Excel 2007 (the
problem did not exsist in Excel 2003).

Thanks,
Drew
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Excel 3-D Pie Chart Flaw & Test

There is a conceptual flaw with 3D pie charts specifically, and with pie
charts in general. Pie charts do not convey data clearly, but they are so
familiar, people do not notice. 3D charts reduce the clarity of the data
they present, but people again are too familiar with them to notice. The
combination of 3D and pie charts can only be made worse by exploding the pie
or using multiple pie charts.

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


"Drew" wrote in message
...
I believe there is a flaw with the boarders on 3-D pie charts in Excel
2007.
Try to enter some data - say 6 names with unequal percentages that sum to
100%. If you chart this data using a 3-D pie chart and give the pie
itself
and the pieces of pie black boarders the boarders are very jagged. These
jagged boarders are easy to see in a zoom view or if you print the pie
chart
out. Thank you in advance to anyone who can test this in Excel 2007 (the
problem did not exsist in Excel 2003).

Thanks,
Drew



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 39
Default Excel 3-D Pie Chart Flaw & Test

Jon,

Thanks for your response. I agree with the fundamentals of your replay but
my question is much simplier than you may think. First, I need to use a pie
chart. Second, I know for a fact that this problem did not exist in Excel
2003. My conclusion is that either there is a trick to getting boardered 3-D
pie charts to work correctly in Excel 2007 or Excel 2007 has a bug.

Drew

"Jon Peltier" wrote:

There is a conceptual flaw with 3D pie charts specifically, and with pie
charts in general. Pie charts do not convey data clearly, but they are so
familiar, people do not notice. 3D charts reduce the clarity of the data
they present, but people again are too familiar with them to notice. The
combination of 3D and pie charts can only be made worse by exploding the pie
or using multiple pie charts.

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


"Drew" wrote in message
...
I believe there is a flaw with the boarders on 3-D pie charts in Excel
2007.
Try to enter some data - say 6 names with unequal percentages that sum to
100%. If you chart this data using a 3-D pie chart and give the pie
itself
and the pieces of pie black boarders the boarders are very jagged. These
jagged boarders are easy to see in a zoom view or if you print the pie
chart
out. Thank you in advance to anyone who can test this in Excel 2007 (the
problem did not exsist in Excel 2003).

Thanks,
Drew




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Excel 3-D Pie Chart Flaw & Test

I'm leaning towards bug. However, they changed a lot of the way that charts
and shapes are rendered, so the official response may be "feature". I don't
like the way exported charts, or pasted-as-picture charts look in 2007.

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


"Drew" wrote in message
...
Jon,

Thanks for your response. I agree with the fundamentals of your replay
but
my question is much simplier than you may think. First, I need to use a
pie
chart. Second, I know for a fact that this problem did not exist in Excel
2003. My conclusion is that either there is a trick to getting boardered
3-D
pie charts to work correctly in Excel 2007 or Excel 2007 has a bug.

Drew

"Jon Peltier" wrote:

There is a conceptual flaw with 3D pie charts specifically, and with pie
charts in general. Pie charts do not convey data clearly, but they are so
familiar, people do not notice. 3D charts reduce the clarity of the data
they present, but people again are too familiar with them to notice. The
combination of 3D and pie charts can only be made worse by exploding the
pie
or using multiple pie charts.

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


"Drew" wrote in message
...
I believe there is a flaw with the boarders on 3-D pie charts in Excel
2007.
Try to enter some data - say 6 names with unequal percentages that sum
to
100%. If you chart this data using a 3-D pie chart and give the pie
itself
and the pieces of pie black boarders the boarders are very jagged.
These
jagged boarders are easy to see in a zoom view or if you print the pie
chart
out. Thank you in advance to anyone who can test this in Excel 2007
(the
problem did not exsist in Excel 2003).

Thanks,
Drew






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
FYI - Microsoft Acknowledges XL Flaw RagDyer Excel Discussion (Misc queries) 13 January 18th 08 02:29 PM
FYI - Microsoft Acknowledges XL Flaw RagDyer Excel Worksheet Functions 13 January 18th 08 02:29 PM
3rd Security Flaw Found In XL RagDyeR Excel Discussion (Misc queries) 1 July 8th 06 08:02 PM
*Second* Zero-Day Excel Flaw RagDyeR Excel Discussion (Misc queries) 1 June 21st 06 07:46 PM
How to make many random test outcomes in one chart? vegas Excel Discussion (Misc queries) 4 July 11th 05 11:03 AM


All times are GMT +1. The time now is 04:24 PM.

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

About Us

"It's about Microsoft Excel"