Graph repeats after each data

[Karoll94]

Hello



I'm creating a report about hotel rooms. I have three types of rooms (A B, C) and data for each of them (duration of stay, number of guests etc.). I want to compare two data - duration and number of guests to show that one type of room gives a profit. So, I created a graph. Everything is ok in project view, but it looks like this:
A [further data]
graph
B [further data]
the same graph
C [further data]
the same graph.

I'd like to to have it like these:
A [data in columns]
B [data in columns]
C [data in columns]

Graph.

One more thing - I changed the graph into image because when it splitted the data into three (by type of room) it splitted the graph as well so each one ofthem showed one column instead of 6.
How do I do this? Please help me ASAP; we're doing management project and I can't deal with Access. Will be greatful for any help

[June7]

Put the graph in a header or footer section.

I analyse graph issues best when I can work with data. If you want to provide db, follow instructions at bottom of my post.