Two constants in chart

  • Thread starter Thread starter Snedker
  • Start date Start date
S

Snedker

I've got a curve diagram based on a row: B20:B45

In addition to this I wish to show the line of two constants. One
given in J40, another in K40. These are to be shown in the graph as
horizontal lines showing an upper bound and lower bound (to show if
values of B20:B45 are too high or too low).

Can I make one long line representing e.g. the lower bound, based on
one value - if yes: how?

Thanks in advance.

/Snedker
 
You'd have to use a named formula. See the Excel | Charts | 'Straight
Lines' page of my web site for one possible method.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
You'd have to use a named formula. See the Excel | Charts | 'Straight
Lines' page of my web site for one possible method.
Click to expand...

Thx! Your site is added to my most wanted! :-)

/Snedker
 
You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top