Effective Data Visualization: The Right Chart for the Right Data by Evergreen Stephanie D. H

Effective Data Visualization: The Right Chart for the Right Data by Evergreen Stephanie D. H

Author:Evergreen, Stephanie D. H. [Evergreen, Stephanie D. H.]
Language: eng
Format: azw3
Publisher: SAGE Publications
Published: 2016-05-03T16:00:00+00:00


The backbone of the lollipop graph is a scatterplot, which means we will need x-values and y-values. The x-values are easy—those are my survey responses. The y-values are going to be faked, just inserted to make each lollipop equidistant from each other. So Figure 5.26 shows the new data table, with my actual survey responses and a new column next door where I typed in placeholder data, from 1 to 21.

Excel Ninja Level: 8

Now highlight both columns with numbers and insert a simple scatterplot (Figure 5.27). Don’t highlight the data labels or the header row, or else the graph won’t work out properly.

Figure 5.27 Your graph should be a series of dots.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.