Darryl Collins
darryl at whittleconsulting.com.au
Thu Oct 18 18:33:37 CDT 2012
This would not surprise me, I know in XL2007 when it was first released that the charting features in Excel was not 100% functional or complete (including VBA as well - indeed in VBA much of it just didn't work at all). MSoft did include numerous improvements and fixes in XL2010 (and Office 2007 SP1), but I am sure it is still lacking in some areas. For a good overview of what is good, bad, ugly I suggest the following link is worth a quick visit <<http://peltiertech.com/WordPress/changes-to-charting-in-excel-2007/>> Jon Peltier is one of the leading voices on Excel and Charts. Cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Philippe lelynx Sent: Thursday, 18 October 2012 8:18 PM To: Access Developers discussion and problem solving Subject: [AccessD] Excel2007-2010: Non linearity in 100% stacked bar chart Hi all, Excel2007-2010 The 100% stacked bar chart has a non linear behaviour! Experiment: You build a 100% stacked bar chart based on 2 cells, each containing a percentage value, the sum of them being 100%. The proportion of each bar is ok until 83%-17%. Starting from 84%-16% until 100%, the 84% bar becomes smaller than the 17% bar. NB: with Excel 2002, the 100% stacked bar chart is ok! Did you get this already? Any hints? Thank's in advance, Philippe -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com