It is the holiday week, that means less posts and more fun. We went to a friend’s wedding yesterday and had wonderful time. We are planning to celebrate Christmas at home with friends this year. How are you celebrating the holidays this year?
Off to this week’s excel links,
Editing Data Series references in Charts
Creating charts is probably the most time consuming tasks when it comes to using excel. Jon takes a look at editing data series formulas and provides a simple add-in that you can use if you make lot of charts on regular basis.
Garr at Presentation Zen lists ten simple rules for good design, even though he wrote it from presentation point of view, most of them are relevant for spreadsheet design. Take a look and implement one of them today in your report or chart.
Creating table of contents in your workbooks
Ever built a large work book with more than 5 sheets? It might be helpful to include a navigation sheet where you provide links to other sheets. Debra at Contextures blog shares few tips on making ToC for your workbooks.
Making beautiful charts using Adobe Illustrator
Even though excel is a very good tool for making charts often you may need a design quality software to make charts. Nathan at Flowingdata has posted a detailed tutorial discussing how to make charts using Adobe Illustrator.
Eight must have features for real time dashboards
Juice analytics lists down 8 features that dashboard makers should keep in mind while designing. Of course if you are stuck at building, do check our tutorials on excel based dashboards.
Happy holidays everyone 🙂
4 Responses
Hey do you sales earning post of previous month.
Tell us how many visitors you got, how much you made, what improvement in rankings you made etc.
A genuine big “THANKS” to you for your time and effort to share great tips through PHD. Happy Xmas and long life to PHD… Ciao !
@Tarun: Welcome. I share some of the traffic details in best of month posts. Last month we had 150k page views with 60k visitors. Every month the number of visitors / pageviews has been growing. So is the RSS subscriber base. I cant divulge the sales / ad revenue data, but I can tell you this much : I am still working 9 to 5 to make a living. So this blog has a looong way to go before I can probably say I am making very good money doing this. But I am writing this because I enjoy learning and sharing about excel and related stuff.
@Fabrice: Thank you so much and I wish you the same 🙂
Check out this article on Binaryday comparing earnings of different blogs –
http://binaryday.com/2008/12/20/the-november-earning-report-of-7-bloggers-and-what-we-can-learn-from-them/