gridlines in a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top