I know there's a few people good with Excel here. I love using it but I'm not that great with it!

I'm doing a building occupancy/predictions study for work.

My boss wants some graphs of it so he can show management easily when we're going to run out of space for people.

So basically I'm just plotting a table of occupancy versus time. The graph needs to show the increase in occupancy with another line showing the building capacity (a horizontal line as this is constant).

Where the 2 line intersect is where the building's full- easy!

However, what I want to know is, is it possible to have the capacity line extend across the chart without filling an entire row of cells with this figure?

Here's a quick version of what I've done:

[img]
Building occupancy [/img]


You can see the capacity line is made up by filling a whole row of cells with the same figure. This seems a really clunky way to get a line across the whole chart. I have several of these to do in one chart (several building) so it means loads of ugly lines of pointless numbers in the table.

If anyone can show me how to get a line across the chart without filling hundreds of cells it'd be great!

Thanks!
James

You only need to have x,y values for the two end points of the line, but it must be independent of the variable you are graphing; if you use a common x column for two or more y columns on a graph then you have to fill in all the cells in each y column or it won't draw a continuous line.

So, just graph a separate "series" on the same graph, with the two end points. On your graph: four cells - 2012,300 and 2014,300 will draw your horizontal line.

I tend to plot graphs in columns, but the above applies to x and y rows if that's how you have arranged your series.

Cheers R

That would seem the normal way of doing it.
You can drag the value to fill the range though you don't need to keep typing it.
Or you could just draw a lone on the graph at the right place
Or you could insert a linear trend line

Thanks for the help guys!