Sunday, June 12, 2011

yogi_Insert A Chart Image In Blog And Then Resize The Image By Enlarging The Chart In Spreadsheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
zodac said ...
I'm publishing the chart itself, using the "image" option. While the chart takes up most of the page when editing, the published image is aroung 600x400 pixels.
Is there any way to increase the size?

--------------------------------------
When a Chart is published as an Image, in the code that is produced, there are no attributes for adjusting the width and the height of the image

following is the code that was produced by Clicking on the top left hand corner of the Chart to Publish chart as Image (not Interactive Chart) ... code is shown without the opening and closing angle brackets ...
img src="https://spreadsheets.google.com/spreadsheet/oimg?key=0AkHBcyclu11AdDlRcVJlX0FwVDVPZmJOSE1DLWZBNVE&oid=12&zx=m7s42n8q3ihs" /

to facilitate having control over the width and the height of the Chart published as Image, I moified the code by adding the width and height parameters -- the modified code is hown below without the opening and the closing brackets ...
img src="https://spreadsheets.google.com/spreadsheet/oimg?key=0AkHBcyclu11AdDlRcVJlX0FwVDVPZmJOSE1DLWZBNVE&oid=12&zx=m7s42n8q3ihs" width=765 height=300 /

and finally here is the Chart with the height and width as specified

2 comments:

  1. Specifying width and height on the img tag just makes the browser "distort" the image to fit in the assigned space. It does not affect the size (and hence resolution) of the image produced by the spreadsheet. It seems strange that there is no way to do this.

    ReplyDelete
  2. Coding is not a necessary skill to create data visualization in Microsoft Excel and Google Sheets in this article, we will show you How to Create Pareto Chart with great graphic to make your visualization sophisticated.

    ReplyDelete