Help making a simple graph

Hi I'm having incredible difficulty making a simple graph with this fantastic piece of software . This is all I need

X values: 1, 3, and 6

On the y axis, right above each one of the X values, I want the different values.

Let's say House number 1 has had 4, 5, and 6 people in it. So I just need an x value of 1, with three dots above it representing 4 5 and 6.

Thanks

Thanks almost! but I need to change the x-axis values to be words instead of numbers.

like this?

I think it worked. Thanks so much.

You are welcome

If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.

HI! It worked almost perfectly; but is there a way to make the colors match? As in each column has it's own distinct colors? Thanks again!

select serie
format
marker
and choose size, color etc... as you want

Originally Posted by sandy666

select serie
format
marker
and choose size, color etc... as you want

The problem is each "series" does not match up with the column, it's kind of randomly distributed. I need it uniform for each column.

attach sample workbook (not a picture)