Results 1 to 2 of 2

Thread: Horizontal boxplots with negative values

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Horizontal boxplots with negative values

    Dear All,

    I am trying to do a horizontal boxplot with negative values as shown in the attached excel sheet. However, I am facing several issues with this. I tried to do vertical boxplots (figure a in the attached file) with the same data and was able to successfully create it.

    I essentially employed a similar procedure for the horizontal plot as that of the vertical plot but this is not yielding the results. I used the procedure shown on the blogpro website (Creating a boxplot in Excel 2007 with negative values in dataset).

    It seemed to work fine until I have added the dummy series (violet color series) to the plot (figure b). Once I added the dummy series to the plot and moved the 1st quartlie, median, and 3rd quartile seriesto the secondary axis, my plot (Y-values) is getting reversed. However, the labels on the Y-axis remain the same. I do not understand the reason for this.

    Moreover, when I tried to add the mean values (blue series) to the plot and tried to convert it into a scatter type marker (as done in figure a), a message is popping up saying Some chart types cannot be combined with other chart types. Select a different chart type.

    Can anyone please help me with these issues. The excel sheet is attached.
    Attached Files Attached Files

  2. #2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts