Forum Discussion

Niki0331's avatar
Niki0331
Copper Contributor
Jan 29, 2024

Bar chart

Can anyone help me create a bar chart in excel by answers to questions that were asked in a survey?    I have a survey and need to create a chart by answers.  Hope this makes sense.  
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jan 31, 2024

Niki0331 

Creating a bar chart in Excel based on survey responses is a straightforward process. Here are step-by-step instructions:

Step 1: Organize Your Survey Data

Make sure your survey data is organized in a table with the questions in one column and the corresponding answers in another column. For example:

 

| Question        | Answer   |
|-----------------|----------|
| Q1: Favorite Color | Blue   |
| Q2: Age Range    | 25-34    |
| Q3: Likelihood to Recommend | Very Likely |
| ...             | ...      |

 

Step 2: Select Your Data

Highlight the data you want to include in the chart. This includes both the questions and their corresponding answers.

Step 3: Insert a Bar Chart

  • Go to the "Insert" tab on the Excel ribbon.
  • In the Charts group, select "Bar Chart."

Step 4: Customize Your Chart

Once the chart is inserted, you can customize it:

  • Axis Labels: Excel will automatically use the first column as the axis labels. Ensure that the questions are listed in the first column.
  • Data Labels: You may want to add data labels to each bar to display the actual counts or percentages.
  • Chart Title: Add a title to your chart that reflects the survey topic.
  • Legend: If applicable, you can add or remove the legend.
  • Color: Customize the colors of the bars for better visual representation.

Step 5: Final Adjustments

Make any additional adjustments based on your preferences. You can also experiment with different chart types (e.g., stacked bar chart, clustered bar chart) depending on your data and presentation preferences.

Step 6: Save and Share

Once you're satisfied with your chart, save your Excel file. You can also copy and paste the chart into other documents or presentations. The text and the steps with the help of AI.

These steps should help you create a basic bar chart based on survey responses in Excel.

 

Additional Links:

How to plot survey data in a bar chart

How to Present Survey Results in Excel with a Chart

Creating an excel chart with multiple survey results

How to create a bar graph in Excel

 

MS Templates:  chart Surveys

My answers are voluntary and without guarantee!

 

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

Resources