Wednesday 22 December 2010

How convert Excel charts into bitmap images

I have found information online about making knitting charts in Excel, but once the chart is made, I didn't find a satisfactory method to convert these charts into bitmaps, to use as images online, paste into Word, or to use in PDF documents. A simple screenshot will have poor resolution, especially when working with bigger charts.

This is the method I came up with, there is a bit of going back and forth between platforms, but the result will be a high resolution image.

First, you need to draw your chart in Excel, or a similar spreadsheet program. Using a knitting font such as this one, it will be easy. There are also several tutorials online about drawing your knitting charts with Excel, they will show up in a quick Google search.

Ok, we have our chart finished:



Now we will convert it to PDF format. So let's first select just the chart (or everything we want to export):



Then we will go to the Office Button and click on Save as > PDF or XPS:


We will then click on Options, and select the Selection radio button, then click OK:



NOTE FOR BIG CHARTS
If your chart is very big, it will be cut off in different pages when you export to PDF. To avoid this, in Excel, go to the Office Button > Print > Print Preview. In this screen, click on Page Setup. Under Scaling, set the Fit to to one page wide by one page tall (you may also want to choose landscape if the chart is long), then click OK and exit the Print Preview. When you export the selection onto PDF, it will then be fitted to one page wide by one tall.


Now we have a PDF file in the destination folder we chose, with the chart in it. If you want to publish only your chart in PDF format (you can also add a little text in the Excel file), this will be your last step.

To convert to image, we will now need to open the PDF in a program that will allow us to do this, like for example GSview.



We will now go to File > Convert, and in the menu choose jpeg and 600 resolution, then click Ok:


Don't forget to add the .jpg extension when chosing a filename.

Now we have a high resolution jpeg file in the destination folder we chose. We can now edit this image in an image edition program such as IrfanView.

We can crop it and resize it, for example. If you want to use it in Word or for a PDF, you may want a bigger resolution than for web. Let's crop and resize this picture to use it in Word. We select the area we want, then crop it by going to Edit > Crop selection:



We will still have a very big image:


So we will resize it, go to Image > Resize/resample, then choose your width or height:


Now we can insert this image into Word. Open your Word file and place your cursor where you want to insert the image. Then click on Insert > Picture:


And select your cropped image. You can now resize it as you like:


Going one step further, you can also convert your finished word document to PDF for publishing.
Go to the Office Button and click on Save as > PDF or XPS:


Tada!


4 comments:

  1. Thanks for the tutorial! I've never worked with Excel but one has to start it one day :) Will try it on my next pattern.

    ReplyDelete
  2. I hope it will be helpful :)

    ReplyDelete
  3. Thanks for this tutorial, I always use Inkscape for colourcharts but I think this will work better for lace charts.

    ReplyDelete

Note: only a member of this blog may post a comment.