Excel - Graph 1

[elfa]

If I am doing a standard column graph and wish to have a line going across at say 2,000,000 on the Y axis how do I do it?

I was hoping to link to a cell and have the line come up automatically based on the number entered.

Previously I have been drawing a line accross the graph.

Thanks
Elfa

 

[KenWright]

Assuming your data looks like this

aa	        bb
04/08/2005	38
11/08/2005	31
18/08/2005	33
25/08/2005	21
01/09/2005	22
08/09/2005	41
15/09/2005	10
22/09/2005	41

Then just add another data set all of one value linking to a cell you can change, eg:-

aa	        bb	cc
04/08/2005	38	20
11/08/2005	31	20
18/08/2005	33	20
25/08/2005	21	20
01/09/2005	22	20
08/09/2005	41	20
15/09/2005	10	20
22/09/2005	41	20

then just select the new series when it appears in your graph (Make sure that JUST that series is selected), right click and choose chart type and then choose a LINE graph with no markers. Now when you change the cell the values are linked to you will see the line move accordingly.

Regards
Ken...........


----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------