![]() In our chart, fixing the scale at 1 to 5 makes sense. However, the minimum possible score here is 1, and we’ll be using text labels. Note that I’ve violated the first rule of bar chart value axis scales, which is that The Axis Scale Must Include Zero. So far so good, except that the end cap of the Question 3 upper error bar is apparently hidden by the plot area border (it appears properly in 2003). Plot the responses for each question (the first two columns of the data) in a clustered bar chart, and use the Error column as custom error bar values. ![]() I’ve sorted the list in reverse order to work around the phenomenon described in Why Are My Excel Bar Chart Categories Backwards? Let’s assume the following dummy survey results. I’ll show the charts from Excel 2007, and the different dialogs for both where applicable. The steps are essentially the same in Excel 2007 and in Excel 2003. In this tutorial I’ll show how to use a combination bar-column chart, in which the bars show the survey results and the columns provide the text labels for the horizontal axis. There are several ways to accomplish this task. The data can be plotted by value, but it’s not obvious how to place the text labels on the chart in place of the numerical labels on the horizontal axis. This may be a scale of 1 to 5 where 1 means “Completely Dissatisfied” and 5 means “Completely Satisfied”, with other labels in between. When analyzing survey results, for example, there may be a numerical scale that has associated text labels.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |