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:

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:


Monday, 20 December 2010

First post

I have decided to start a blogger knitting... blog ;P

I also have a knitting livejournal, but 90% of my posts there are private, notes to myself, pattern notes, links to other websites, wishlists, stuff like that. The one useful post there may be this one: Online Yarn Shops in Europe. Maybe I should copy it here later on. This list was compiled with the help of many helpful members from Ravelry. My username in Ravelry is medvssa.

Despite the fact that I only started knitting in March 2009, I love it and I have a lot of ideas, so I have started writing my own little patterns. I think I will put them up in Ravelry, but it would also be a nice idea to have them elsewhere, so this blog will be it. I have also my own website, my enamelled jewellery gallery:, so I can host my patterns there.

And that will be all for now, I guess ;P A mitten pattern or two coming very soon!