You are currently offline, waiting for your internet to reconnect

Percentage-formatted data in an Excel 2007 chart data table has a value that is 100 times larger than the actual value when you view the chart data table in Excel Web Access

SYMPTOMS
When you view a Microsoft Office Excel 2007 chart data table in Microsoft Office Excel Web Access, the percentage-formatted data in the chart data table has a value that is 100 times larger than the actual value. This problem occurs if the following conditions are true:
  • The chart data table has a series data source.
  • The values are formatted by using the Percentage cell format.
For example, if the chart data table contains a value of 2.00 percent for a parameter, the value appears to have a value of 200.00 percent when you view the chart data table in Excel Web Access.
WORKAROUND
To work around this issue, type a value that is 100 times smaller than the value that you originally typed. For example, instead of typing 2.00 for the parameter, type 0.02. Then, the value will be displayed as 2.00 percent, as expected.

Additionally, you can also add calculations to the Excel 2007 workbook that you use to create the chart data table in Excel Web Access. These calculations divide the parameter value by 100.For example, consider a chart data table that uses cells A1:A4. The Percentage cell format is applied to cells A2:A4. Cells C2:C4 are defined as the parameter cells. Each cell in the A2:A4 range has the following calculation:
=C#/100
Note The C# placeholder is a placeholder for a cell from the parameter range C2:C4.

When you edit the chart table data in Excel Web Access, and you type 5.5 in cell C2, cell A2 displays the value as 5.5 percent.
sharepoint server XL2007 Excel2007 MOSS2007 XLServices ExcelServices ECS EWR Renderer
Properties

Article ID: 928325 - Last Review: 10/15/2007 21:37:00 - Revision: 1.2

Microsoft Office Excel 2007, Microsoft Office SharePoint Server 2007

  • kbtshoot kbchart kbformat kbprb kbpubtypekc kbexpertiseinter KB928325
Feedback
>me='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >l>ody>1&t=">