This article is rated as:

 

 

The placement of axis labels in our data visualizations plays an important role in enhancing the clarity and impact of our charts. While Excel is a powerful tool for creating impactful data visualizations, its default charts often leave much to be desired. In previous articles (see Data Visualization Best Practices and 7 Tips for Better Data Visualizations) we have discussed methods for improving the overall look our charts, but we have not discussed how to justify y-axis labels in our bar and stacked bar charts. In this article, we will discuss a quick approach for justifying our y-axis labels within the Microsoft suite of applications (e.g., Word and PowerPoint), as well as a workaround for justifying y-axis labels directly in Excel.

---

The Problem

First, it is important to highlight the problem with the default y-axis labels in Excel. On creation of a new chart, whether a bar or stacked bar chart, the first row of text is justified to the left edge of our bars, but subsequent lines are centred below the first line of text. This leads to awkward looking labels that distract from the overall appeal of the chart. While this issue may not be immediately apparent if y-axis labels are short in length or if the chart is large enough to allow sufficient room for the full label to display in a single line, this becomes an issue when we are wanting to plot charts with lengthy y-axis labels. For example, a label may be a survey or evaluation question that is being addressed.

To illustrate this, the example below depicts the default y-axis labels of five staff engagement questions. Some labels will be justified as needed, but others will require editing to improve the overall look of the chart.

---

The Simple Solution

The simplest solution for justifying the y-axis labels is to leverage other Microsoft suite applications (e.g., Word or PowerPoint), as Excel does not have a simple approach for justifying these labels without additional data preparation.

---

How to Justify Y-Axis Labels in PowerPoint or Word

1. Copy & Paste (Ctrl +C, Ctrl + V) the Excel chart into PowerPoint or Word.

2. Left-click on the y-axis labels (Vertical (Category) Axis).

3. Within the Home tab, navigate to the Paragraph section of the top ribbon.

4. Left click on the arrow icon in the bottom right of the Paragraph section. This will open the Paragraph menu.

5. Under General > Alignment the default will be set to Centered.

6. Change the Alignment to Right.

7. The resulting chart will have right justified y-axis labels.

 

 

---

Right-Justifying Labels in Excel using Chart Templates

While justifying labels in Word or PowerPoint accomplishes the goal of improving the overall look of our charts, this process typically needs to be completed manually for each chart. However, we can leverage chart templates in Excel to apply this formatting to all similar charts within our worksheets.

---

Creating a New Chart Template to Right-Justify Y-Axis Labels

1.     Copy & Paste (Ctrl +C, Ctrl + V) the updated chart back into Excel.

2.     Right click on the formatted chart and Save as Template…

a.     Name the template (e.g., Right justify labels)

3.     With the template saved, right click on any additional chart requiring formatting.

4.     Navigate to Change Chart Type…

5. Go to your saved Templates at the top left of the All Charts tab.

Note: When applying a chart template to another chart, both charts need to be identical in style. For example, a stacked bar chart with five levels of agreement would need to be identical between the template and the chart for which the template will be applied.

6. Select the template you want to apply and click OK.

7. The new template will be applied to the new chart.

 

 

---

The More Complicated Approach

The following approaches work well when working between Excel and PowerPoint (or Word). However, sometimes you may want to justify the labels entirely within Excel. The workaround requires some additional steps in setting up your data but will allow for complete formatting and control within Excel.

---

How to Justify Y-Axis Labels in Excel

1.     Prepare your data for charting.

2. Insert a new column to the left of Column B.

a.     Right click on Column B and Insert.

3. Label this new column as ‘Label’ and insert 0% into all cells below.

4. Highlight the data from Cell B1 (‘Label’) to Cell G6 (7%).

5. Go to the Insert tab in the top ribbon and insert a 100% Stacked Bar Chart.

a.     Right click the new chart and go to Select data…

b.     Switch Row/ Column to get the data presented properly.

6. Add data labels and format the chart as necessary (see Data Visualization Best Practices).

7. The chart will have 0% labels on the left side of the stacked bars. Right click and Format Data Labels…

a.     Under Label Position select Inside End.

8. Also, within the Format Data Labels menu, navigate to the Label Options and select Values From Cells.

a.     Highlight cells A2:A6 (the axis labels) and click OK.

b.     Toggle off the Value and Show Leader Lines boxes under the Label Options.

9. Manually adjust the text boxes for each of the labels by dragging the text boxes (use the circles around the text box to resize) to the far left of the chart.

10. Select all the data labels and under the Home tab > Alignment click on the Align Right option.

---

Wrapping Up

While powerful, Excel has some limitations in its default charting options. However, with the flexibility of the Microsoft suite of applications, as well as additional Excel charting options, it is possible to format engaging charts with a little patience and know-how.

This article is rated as:

 

 

Eval Academy just released a new Infographic: “Types of Interview Guides”

---

Who’s it for?

This infographic is for anyone looking to learn more about the different types of interviewing or for those who are unsure which type of interview guide to use.

---

What’s the purpose?

This “Types of Interview Guides” infographic will help you to:

• Learn about the key characteristics, advantages and potential use of the different types of interview guides.

• Choose which type of interview guide to use in your qualitative data collection.

---

What’s included?

A one-page, downloadable infographic as a png file.

 

 

Download the “Types of Interview Guides” Infographic now!

---

Learn more: related articles and links:

You can learn more about collecting data with professional and ethical conduct in the following Eval Academy articles:

• How to conduct interviews

• 5 tips for ensuring interviewer safety

• How to transcribe interviews like a pro

Other Eval Academy resources that you might be interested in checking out:

• Standard Interview Guide Template

• Standard Interview Information Letter Template

• Standard Interview Consent Form Template

• Tips for conducting interviews

• Standard Interview Templates Bundle

---

What do you think of our new template? Let us know in the comments below!

This article is rated as:

This is a step-by-step guide for linking your surveys in Qualtrics with a participant ID to assess change over time. There are ways to set up these surveys to automate the process to a greater degree than what will be covered in this article. Qualtrics has a support article that has more details for how to do those things such as automating Qualtrics to randomly generate participant IDs or setting up a way to automate the survey distribution to an email list.

The steps below outline ways to for link your surveys with a participant ID that is manually entered by participants, rather than automatically generated, and assigned. Please note that you can only link surveys using a paid version of Qualtrics.

What does it mean to link your surveys?

Linking surveys together means that you’re connecting the data from all your surveys in a way that lets you track an individual respondent. For example, if Kay fills out survey 1 about how they like dogs more than cats, and then changes their mind 6 months later when they take survey 2, you’ll be able to see that pattern in the data on an individual level if the surveys are linked.

Why would I want to link my surveys?

If you want to know how individuals are influenced and change their behaviours or views over time, linking surveys can help you see that in the data at a greater detail than if your data was only in an aggregated form. Linking surveys is a useful method for collecting longitudinal data.

For example, let’s say you were trying to measure the influence of an ad campaign that is trying to get people to like cats more than dogs. You can do a regular survey BEFORE the ad campaign runs and find the total percentage of people who like cats more than dogs. And then you can do another regular survey AFTER the ad campaign to see if that percentage has increased. However, your results won’t tell you if most of the people who changed their opinions were between the ages of 30-40. It also wouldn’t tell you if some people who liked cats more than dogs changed their minds too. Linking surveys can allow you to see more details in the pattern of your results.

Does linking surveys reveal a participant’s identity?

Linking surveys lets you track individual data confidentially. You can set up linked surveys so that any personally identifying information is not linked directly to an individual’s response. This means that when you are looking at the survey data, you’ll see the answers given by participant 1, but you won’t know their specific name or contact information. A confidential survey is different from an anonymous one. Linked surveys cannot be anonymous because they generate a list of everyone who has taken the survey. If you are using this method, it is important to help your participants understand that while their responses are confidential, they are not anonymous.

To learn more about the difference between confidentiality and anonymity in evaluation, check out, “Your information will be kept confidential: Confidentiality and Anonymity in Evaluation.”

Before we get to the details, I want to remind you that it is best practice to test the survey functionality and pilot it prior to sending it to participants.

How to manually link surveys in Qualtrics

Setting Up Survey #1

1.     Create your first survey in Qualtrics as if you are setting up a regular survey.

2.     Create a survey question that will determine the participant ID. This is the ID that a participant will need to remember and enter to access the second survey.

For this guide, we will use the participant’s email address as the ID. We chose to create a text entry question with an email address validation that asks, “What is your email address?”. You can choose a different identifier like a phone number or a name – something that the participant will remember easily. Make sure you make this question mandatory. It is recommended that you put this question near the beginning of your survey so that participants will fill it out even if they exit the survey early.

3.     Go to the “Survey flow” tab.

4.     Select “Add a New Element Here.”

5.     Select “Embedded Data.”

6.     Type in a label for your participant ID. Since we’re using email addresses, we just wrote, “Email Address.” Do NOT select an option from the drop-down list.

7.     Next, click on “Set a Value Now.”

8.     For “Set a Value Now,” you will need to choose the survey question that you had created for your participant ID. In the drop-down list, select “Insert Piped Text,” then “Survey Question.” Find the question you created for the participant ID. There will be one more panel that appears with options. Select the box that has the actual question. For us, it is “What is your email address?” Do NOT select “Question Text.”

9.     Select “Apply.”

10.     Next, go to the “Workflows” section.

11.     Select “Create a workflow” and choose the option “Started when an event is received.” Another page will pop up that will list different types of extensions.

12.     Choose the extension “Survey response” by Qualtrics. This means that you are now creating a workflow within Qualtrics that will be triggered when someone responds to your survey.

13.     In the next set of options that appear, make sure that “Newly created responses” is checked. You can make selections under “Additional response types” as you prefer. Select “Finish” when you are done.

14.     Next, select the plus sign (+) and then select “Add a task.” Another panel with an extension will appear.

15.     Select the extension “XM Directory” by Qualtrics.  

16.     Select “Add to XM directory.” A new panel with fields will appear. What you will be doing at this point is creating a contact list for participants that will be stored on Qualtrics. This contact list is how Qualtrics will recognise the participant IDs when they are entered to access the second survey.

17.     Select the drop-down box for “Contact List.” From there, you will select “My Library,” and then “New Contact List.”

18.     Create a name for your participant contact list. Then select “Save” to exit the window.

 19.     Next, select the drop-down box for “External reference ID.” From the list, select “Embedded Data Field” and then select the name of the label you created for your participant ID in step 6. For us, the name we chose was “Email Address.”

20.     Leave the other settings under “Contact update options” as the default settings. This means that “Save or update it as embedded data to your XM directory contacts” is selected and “Update recipient from survey response” is checked. Save to exit the window.

21.     Your first survey is now ready to be distributed. After publishing your survey, make sure you use the “Get a single reusable link” option from the “Distributions” tab. That will give you a single anonymous link that can be sent to all the participants. This survey shows as a regular survey. When the respondent submits their response, their information will get added to the contact list associated with your survey.

Congratulations! You have just set up your first survey! Try testing it out and if you encounter any problems, contact Qualtrics Support and someone will help you troubleshoot your issues.

In my experience, it takes Qualtrics a few minutes to update your survey with the changes you’ve made. If you don’t see your changes right away, wait and try again before contacting  Qualtrics Support.

Setting Up Survey #2

22.     Create your second survey like you would for a regular survey. This one doesn’t need a specific question for the participant ID. If you are asking the same questions as survey #1, I would recommend copying that survey and editing it to make sure your questions are worded in the same way.

23.     Go to the “Survey flow” tab and select “Add a New Element Here.”

24.     Select “Authenticator.”

25.     Select “Move” on any question blocks you have and move them underneath the Authenticator element. If you have multiple question blocks, be sure to move and arrange them in the correct order for your survey.

26.     “Authentication Type,” should be set to “Contact.” And under “Authenticate Using Contact,” select the same library you used in step 17 of survey #1. When you select the library, another drop-down list will appear for contact lists. Select the contact list you created in in step 17 of survey #1.

27.     After selecting your contact list, another section called “Authentication Fields” will appear. Under this section, select “External Data Reference” in the drop-down box, then type in the label you chose for the participant ID you selected in step 6 of survey #1. For us, we had chosen “Email Address” so that is what we wrote in this box. Leave the “Password” and “Pre-fill” boxes UNCHECKED. Apply your changes.

28.     After publishing your survey, it is now ready to be distributed. When you are sending it out, make sure you use the “Get a single reusable link” option from the “Distributions” tab. That will give you a single anonymous link that can be sent to all the participants. After receiving the link, they will be taken to a page where they will have to enter their participant ID before accessing survey #2. Requiring participants to enter their participant ID ensures that their survey #2 responses are linked to their survey #1 results.

Anyone who has not taken survey #1 will NOT be able to access survey #2, unless you add their contact info manually to the corresponding contact list in Qualtrics. This is the contact list you created in step 17 of survey #1.

And that’s it! You have just linked your second survey to your first! If you don’t get the result you want after testing it out, contact Qualtrics Support and someone will help you troubleshoot your issues. Sometimes it takes a few minutes for Qualtrics to update your changes. So, if you don’t see your changes right away, wait a few minutes to test again before contacting  Qualtrics Support.