graphs in excel

L

lceddia

i am trying to create a graph where i can plot a data series, but also show a
min and a max line as a range. For example I dont want my data series to go
above or below a certain number and i want to see easily on a graph when the
data series has gone above or below that range. any help would be great!

thanks!
 
D

Del Cotter

i am trying to create a graph where i can plot a data series, but also show a
min and a max line as a range. For example I dont want my data series to go
above or below a certain number and i want to see easily on a graph when the
data series has gone above or below that range. any help would be great!

Plot *three* data series, one consisting of your data, another your min
value repeated down the column, and the third your max value repeated
also.
 
F

FloMM2

Iceddia,
As Del said, just put your lower limit in one column, your data in another
column, and your upper limit in the last column.
Select all three columns, use the graphing wizard.
Label the limits and you should be happy with the results.
hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top