gridlines in a chart

[smason]

Hello i have a chart showing some data (see below) and i want to put a line
which represents a target at 50000 and 80000 (as shown) along with the data
in the chart can this be done????

thanks in advance

10000
90000
80000-----------------------------------------------------
70000
60000
50000 -----------------------------------------------------
40000
30000

a b c d e

 

[David Biddulph]

Yes. Add a dummy series:
a 80000
e 80000
Add this as an extra series to the graph (easiest way is to copy the data
range above & paste special into the graph).

Similarly for 50000

 

[Jon Peltier]

Add a Line:
http://peltiertech.com/Excel/Charts/AddLine.html

- Jon

 

[smason]

Hello

i have a column chart though and this gives me vertical columns??

 

[David Biddulph]

So you'll need to change the extra series to an XY chart, and may need to
stretch the data to cover the whole width of the graph.