30 Chants for Better Charts

Publish in

Documents

32 views

Please download to get full document.

View again

of 13
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Description
excel tips
Tags
Transcript
    30 Chants for Better Charts Mynda Treacy   i Contents About the Author .......................................................................................................................... ii Preface ......................................................................................................................................... iii Less is More - KISS ......................................................................................................................... 1 Know Your Audience...................................................................................................................... 2 Formatting .................................................................................................................................... 3 Excel Formatting Shortcuts ............................................................................................................ 7 Products ........................................................................................................................................ 8 Mynda’s Excel Dashboard Course  .............................................................................................. 8 Jon Peltier’s Chart Utilities  ......................................................................................................... 8 Resources ...................................................................................................................................... 9 Edward Tufte ............................................................................................................................. 9 Stephen Few .............................................................................................................................. 9 The Frankens Team .................................................................................................................... 9 Disclosure ...................................................................................................................................... 9   ii  About the Author  Mynda Treacy was first exposed to the power of a spreadsheet with Lotus 1-2-3 and has been using Excel since 1995. In 1999 she qualified as a Management Accountant in London where she was the Global Financial Controller for the Information and Technology department of a multinational investment bank. In 2010 she co-founded www.MyOnlineTrainingHub.com to pursue a passion for Excel and the desire to help other’s get more out of it. She has since helped thousands of people overcome their Excel challenges, and all from her desk on Queensland’s Sunshine Coast, Australia.  At her website she writes a weekly Excel newsletter and runs an online Excel Dashboard course, which to date has taught over 600 students how to wrangle Excel to produce informative and interactive dashboard reports.   iii Preface I see the same innocent mistakes with charts and data presentation over and over again. And a lot of them are easily avoided. In this book I share with you 30 easy to action tips on how to create better charts in Excel and the common pitfalls to avoid. I’m a big fan of data visualisation pioneers Edward Tufte and Stephen Few. For without their teachings on data visualisation and dashboard design I would most likely be making those same mistakes. I am grateful to Excel Chart Gurus like Jon Peltier and The Frankens Team who give me inspiration (and solutions) for what can be achieved with an Excel chart that goes way beyond what Microsoft had intended.
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x