gridlines in a chart
 

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

gridlines in a chart
 

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
--
David Biddulph

"smason" wrote in message
...
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

gridlines in a chart
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"smason" wrote in message
...
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

gridlines in a chart
 

Hello

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

"David Biddulph" wrote:

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
--
David Biddulph

"smason" wrote in message
...
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

gridlines in a chart
 

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.
--
David Biddulph

"smason" wrote in message
...
Hello

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

"David Biddulph" wrote:

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

"smason" wrote in message
...
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