Chart size using excel services

Question

Hi,
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.
Thanks in advance
yayomayn 

Answer 1

You 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.

---

S/W Engineer, Microsoft Office Excel Services

Answer 2

Thanks for the reply Anthony.
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?

Thanks again
yayomayn

Answer 3

The 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 "named item" in the drop down.  Xlviewer definitely won't.

---

S/W Engineer, Microsoft Office Excel Services

Answer 4

Ok, thanks for your help Anthony :-)