Chart size using excel servicesHi,<br/>I am publishing several charts onto sharepoint using named items from an excel 2007 workbook. When I view them the display is fine but when some (not all) other people view them they are cropped and the user has to scroll to see the full chart. Is there anything I can do to stop this happening? I suspect it's to do with different screen sizes/resolutions but if there is a way around this in sharepoint that would be great.<br/>Thanks in advance<br/>yayomayn © 2009 Microsoft Corporation. All rights reserved.Fri, 03 Jul 2009 11:42:36 Z308f3e06-ebd3-479d-a9a0-5858c31a8c6dhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/308f3e06-ebd3-479d-a9a0-5858c31a8c6d#308f3e06-ebd3-479d-a9a0-5858c31a8c6dhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/308f3e06-ebd3-479d-a9a0-5858c31a8c6d#308f3e06-ebd3-479d-a9a0-5858c31a8c6dyayomaynhttp://social.msdn.microsoft.com/Profile/en-US/?user=yayomaynChart size using excel servicesHi,<br/>I am publishing several charts onto sharepoint using named items from an excel 2007 workbook. When I view them the display is fine but when some (not all) other people view them they are cropped and the user has to scroll to see the full chart. Is there anything I can do to stop this happening? I suspect it's to do with different screen sizes/resolutions but if there is a way around this in sharepoint that would be great.<br/>Thanks in advance<br/>yayomayn Wed, 01 Jul 2009 11:09:51 Z2009-07-01T11:09:51Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/308f3e06-ebd3-479d-a9a0-5858c31a8c6d#fb91327e-34ee-49eb-b621-3f8174a26e76http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/308f3e06-ebd3-479d-a9a0-5858c31a8c6d#fb91327e-34ee-49eb-b621-3f8174a26e76Anthony Valey - MSFThttp://social.msdn.microsoft.com/Profile/en-US/?user=Anthony%20Valey%20-%20MSFTChart size using excel servicesYou can explicitly set the 'width', 'height' and 'named item' properties of the Excel Web Access (EWA) webpart.  These are very useful for building dashboards.  Otherwise, the size of the browser and other webparts in zones will affect the sizing of the EWA webpart.<hr class="sig">S/W Engineer, Microsoft Office Excel ServicesWed, 01 Jul 2009 16:45:08 Z2009-07-01T16:45:08Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/308f3e06-ebd3-479d-a9a0-5858c31a8c6d#e426480a-33b4-4bca-a92b-0a96e062d4b6http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/308f3e06-ebd3-479d-a9a0-5858c31a8c6d#e426480a-33b4-4bca-a92b-0a96e062d4b6yayomaynhttp://social.msdn.microsoft.com/Profile/en-US/?user=yayomaynChart size using excel servicesThanks for the reply Anthony. <br/>The thing is I am not publishing them as a dashboard, I am using the report viewer and each chart is selected as a view. When published in this way there is no way to change the height and width properties of the webpart that I know of. They are appearing in quite drastically different sizes on different machines but is there a way I can make them uniform?<br/><br/>Thanks again<br/>yayomaynThu, 02 Jul 2009 10:01:24 Z2009-07-02T10:01:24Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/308f3e06-ebd3-479d-a9a0-5858c31a8c6d#1988c3bb-c9ef-4812-94bd-a29c7315e6c0http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/308f3e06-ebd3-479d-a9a0-5858c31a8c6d#1988c3bb-c9ef-4812-94bd-a29c7315e6c0Anthony Valey - MSFThttp://social.msdn.microsoft.com/Profile/en-US/?user=Anthony%20Valey%20-%20MSFTChart size using excel servicesThe intent of the report viewer (xlviewer.aspx) is to allow the user a larger working space to navigate and view the published item, or sheet.  So... if the user has a large monitor then they just get more real estate by design.  I don't remember if in a dashboards the EWA will dynamically size up/down to the content when you change the &quot;named item&quot; in the drop down.  Xlviewer definitely won't.<hr class="sig">S/W Engineer, Microsoft Office Excel ServicesThu, 02 Jul 2009 18:41:07 Z2009-07-02T18:41:07Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/308f3e06-ebd3-479d-a9a0-5858c31a8c6d#7d0e1163-b10b-4869-bfc6-177306b00401http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/308f3e06-ebd3-479d-a9a0-5858c31a8c6d#7d0e1163-b10b-4869-bfc6-177306b00401yayomaynhttp://social.msdn.microsoft.com/Profile/en-US/?user=yayomaynChart size using excel servicesOk, thanks for your help Anthony :-)Fri, 03 Jul 2009 11:42:29 Z2009-07-03T11:42:29Z