Book Image

Data Analysis and Business Modeling with Excel 2013

Book Image

Data Analysis and Business Modeling with Excel 2013

Overview of this book

Table of Contents (18 chapters)
Data Analysis and Business Modeling with Excel 2013
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
10
Creating Interactive Spreadsheets Using Tables and Slicers
Index

Chapter 9. How to Build and Style Your Charts

Visually representing your data can arguably be called an art. Going from data to visualization, or "viz" for short, can actually be a lot of work. Just think about it; we have to first get the data, prepare it, analyze it, and then, we can finally try to chart it. Does this ring a bell? Yes, this is the data analysis life cycle we have been talking about over and over in this book. Now, my last statement does not mean that the only time you build a chart is at the end. Early in your exploratory phase, plotting your data can be very valuable in getting to know what you are working with. In this chapter, we are going to explore many of Excel's charting features and get you started with building vibrant visualizations. We will start with the quick and dirty charting options and then meticulously tweak our charts so that they convey the story you are trying to get across. We will not be going through every chart type and will only concentrate on...