Hi all,
I’m the latest addition to the vzaar crew and it’s an honour to be here. I’ll be focusing on vzaar’s search engine marketing efforts, so expect my posts to be themed around that topic.
When I started a week ago, one of the priorities were to create a reporting template that would allow us to oversee all aspects of our Adwords and other activities. Hence I started to put together a sophisticated reporting tool in Excel. Charts naturally accompany such spreadsheets as they help you to visualize data.
I used to use a special kind of chart quite a lot at previous jobs, the one that displays two, different kinds of data, like impressions (a simple number value) and click-through-rates (a percentage value). In Office 2003 and prior versions, it’s quite easy to produce something like that, all you need to do is to choose the right kind of chart and there you go.
For some reason, they eliminated this option from Office 2007, but there’s a workaround to create similar charts.
(1) Firstly, you need to create a regular chart. The data source should include both columns of data
(3) Both values are visible now, all you need to do is to choose a chart type that suits your purposes. In this case, I wanted to see the Impressions represented by columns and CTR by lines. Hence I clicked on the CTR column, chose “Change Chart Type” and changed the type.
4) And we’re done. Enjoy.
I work in digital advertising too, but my focus is email (looks like you are in banners)… This tip is great! Thanks. Able to calculate CPM and Volumes and see trends overtime across diff. platforms.
Matt