Help with Box Plot

[zainmerchant]

Hi guys, I'm working on an assignment of mine for which I have to create Box Plots.

The box plot should be based on the data provided and the data has been categorised into 4 different categories VLD, LD, MD and HD. I am able to make the box plots and everything but my Y-Axis should show the box-plots categorised into these 4 categories. But my box plot only shows 1 in the Y-Axis unfortunately.

I have been at this for an hour looking for help on youtube but nothing seems to help. The chart is on the 2nd table of the Excel file. And also, there are multiple dots showing on each box plot which I can't seem to get rid of :/

Any help will be appreciated.

Following is the exact requirement:
"Create one chart that provides the box and whisker plots for the “Prevalence (%) of owner households spending 30% or more of its income on shelter costs” values in each category of the “PopDens” variable. The horizontal axis will be the description of the population density of each census tract (High, Medium, Low, Very Low). Ensure the horizontal axis is ordered from lowest to highest population density (by ensuring the “PopDens” variable is ordered). In other words, you should have four boxplots in the chart (one for each population density category), ordered from Very Low to High. The vertical axis should represent the “Prevalence (%) of owner households spending 30% or more of its income on shelter costs” variable. Make sure that the chart is legible with an appropriate title, appropriately labelled horizontal and vertical axes, and appropriate values for the horizontal and vertical axis scales. Insert the chart in the “INSERT ANSWERS IN THIS SHEET” (do not paste as a picture)."

[zainmerchant]

Okay I was able to figure it out on my own. I'm not entirely sure how to delete or mark the post as solved?

[MrShorty]

To mark as solved, find the "thread tools" dropdown just above the first post and select "mark as solved" from this dropdown menu.