How to chart "Power Factor"

[Guest]

Can anyone tell me how to create an Excel chart for 'Power Factor', which is an electrical term. Power Factor uses an y-axis 'reference' of 1 (unity), and a typical graph could look like (using Courier New font) that shown below. Power Factors above the reference line are called 'Leading' Power Factors and are positive, and those below the line are called 'Lagging' Power Factors and are negative.

|
L +0.6| *
e | *
P a +0.7| *
O d | *
W I +0.8| *
E n | *
R g +0.9| *
| *
1 +----------+----------+----*-----+----------+----------+---
0 20 40 *60 80 100 %
-0.9| Percentage of Nominal Load*
F L | * *
A a -0.8|
C g |
T g -0.7|
O i |
R n -0.6|
G |


Thanks for any help which anyone can offer.

 

[Jon Peltier]

In other words, there is a discontinuity in the Y axis scale?

You could fake it using conditioned data and an axis with an arbitrary
scale, following the procedure on my web site:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

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