I’ve had a problem with a table that I’m trying in chart which starts at week 1 through to week 12. At the moment I am only in Week 3 and therefore have no data for weeks 4 – 12.

The problem is that the chart is looking at the data for weeks 1 – 12 and as the data is blank for wks 4 – 12, then the data is shown in the chart as a ZERO – so the line graph suddenly dips after wk 3 – Not what I want!

I still want wks 1-12 shown across the bottom axis to show that this data will be added as we get the data.

Solution:
In the formula in the tables add relevant formula to show an error if the cell is blank or zero. When there is an error in the table the chart (in Excel 2007) ignores the data – which is what I want. For example if the table summarizes data from another table, then =IF(A1=0,na(),A1).

Then use conditional formatting to hide any error values in the table so that the table is still good to be used in any presentations as well.

Here is my lift of gift dates and idea which I will update as I have a number of blanks at the moment:

I was planning on making the tile socks for my brother in law for Christmas but it’s just dawned on my how close his birthday is so best start looking at some wool for these. I think I might also make them for my OH BIL but he is really into his music so first I’ll see if I can find any musically inspired socks before committing to this.

I had already thought of making a cat doorstop for my OH’s sister but my sister also likes cats so I think I should make two and give one to both of the sisters!

Present Bows

I have just been searching the internet for ideas for presents (both birthdays and Christmas) and have found this great article on making your own bows to put onto presents just from magazine pages – fantastic way of  making gifts look nice and glam without spending money  - here is the link to the article.

Door Stops

Here are some lovely doorstops that I would love in my house but the dog would just think they were his playthings – however great gift ideas, the cat would be great for my SIL who not only loves cats but also uses doorstops (of the wooden variety) as I noticed when we went around at New Year

10 Things to Do with a Tea Towel

Ok, so this is borrowed from the Money Saving Expert Forum but here is the list for safe keeping so that I can find it when I need it:

1. for making cakes with for the kitchen- include brush, handcream,rubber gloves and there’s a lovely parcel,
2. peg bags,
3.carrier bag holders,
4.nice thick material for door stops,
5.retro teddies, – possibly microwave bed warmers?
6.teacosy,
7. tote bag
8. Baby bibs http://makeitandloveit.blogspot.com/…-baby-bib.html

I’ve spent the last few months working on getting the look and feel of this website right instead of working on the contect – which, lets face it, is actually the important bit  

It’s just lots of fun for me to mess about with the code and I keep thinking that the rest will sort itself out – but it obviously doesn’t.  I’ve also been busy looking (and getting) a new job, which will actually increase my time away from home instead of improve my work-home life balance as I will have to commute to Manchester every day and no doubt get stuck in the endless jams that I currently only hear about on the radio (my current commute is through gorgeous countryside and I get really excited every time I see the baby lambs!)

In addition to that I have a minor operation about three weeks ago and have been told that I am unable to exercise for 4 weeks which means that the local half marathon which I had been training for (and actually took place yesterday) had to be given a wide berth – still there’s always next year – and that has also meant that I ‘ve been unable to run as well.  Still only one more week of “rest” and I can start running again.  This also co-incides with me starting my new job and I have yet to work out whether the offices have the facilities that will enable me to run during my lunch hour (ie. does it have a shower?) otherwise I will be running in the dark and cold evenings which will certainly be a shock to the system.  Still in order to increase my motivation I have entered (and been accepted) to run in the Edinburgh Marathon next year which takes place in May – so I have to put the training in.

Hopefully I will start to get some more detail in the actual website and slowly get this thing off the ground!  Wish me luck