Excel problem…..any suggestions welcome?
I have a line graph that I have been plotting for a few years in Excel and an annoying problem has developed.
Every week I note down: total clicks on my website, those that were via Google Adwords, those from ‘natural’ results, cost of advertising etc and I plot this against the week number. So I have week number (W1, W2 to W52 and restarting etc) on the horizontal axis and the quantity on the vertical axis. This gives me a visual overview of trends.
In Week 34 (We are in W42 now) the main line (total clicks) stopped plotting. The other lines (cost, Adword impressions, clicks etc) have continued as always. I cannot see any cause for this.!!
Any thoughts? Anyone had something similar?
Has your data exceeded its defined range. Just check your Name Manager (or Define names) and adjust cell references. An easy way to do this is click on each name and see if data exceeds highlighted area. Adjust to incorporate missing data. HTH
Finally Understanding Google Adwords Ranking