To create your own pretty charts, simply follow these quick instructions:
1) Download your CSV file from Google (its above every report you can make) I recommend taking the “All Time†report because if gives a larger sample size.
2) Open Microsoft Excel or a similar spreadsheet application. These instructions are really for Excel, but most spreadsheet packages are similar.
3) Open the CSV file in Excel, youll have a table of figures.
4) Delete only the column heading marked “Date†(for some reason this messes charts up) (dont delete the entire column or you cant tell what youve done over time!)
5) Delete the rows at the bottom of your sheet that indicate Totals. (otherwise you have a spike at the end of your graph which makes everything else hard to interpret)
6) Highlight column A (should be date) and highlight column B (most likely to be Page impressions) and go to Insert > Chart. Go through the wizard (its really simple) looking at the lovely charts you can make. Settle on the first bog standard line graph. Next, Next, Next, until you hit the part that asks where you want to create it (in the current worksheet- no, or in a new worksheet- yes!) Click Finish and bang! Instant charts.
7) Now repeat for A+C, A+D, A+E and A+F.
Save to disk, then print. Analyse, marvel and plot for world domination.
[ From: Webmasterworld ]
After dabbling for years in the IT industry, Paul Tan initially began this site as a general blog covering various topics of personal interest. With an increasing number of readers paying rapt attention to the motoring stories, one thing led to another and the rest, as they say, is history. An avid electronic gadget aficionado as well as big-time coffee lover, he's also the executive producer of the Driven motoring TV programme.
Thanks for the tips, dude!
hey there;s a tool at digitalpoint.com that can generate the charts.here.
dude. you must be making tons of $$$ from your site. you rock.