Charting a constant

**scubohuntr** · 01-17-2007, 01:46 PM

Is there a somewhat elegant way to graph a constant as a horizontal line in combination with a column chart? I have gotten it to work by charting a column of identical values on a secondary axis, but it seems terribly gauche. I have a series of values, ranging from zero to 6.8, and I need to represent a maximum safe limit of 4.0 on the chart for comparison with the columns. My sheet is going to be a part of the report, and the "column of 4's" approach seems to me to be too much like writing the report in crayon.

**Carim** · 01-17-2007, 02:03 PM

Hi,

Take a look at Jon's nice solution ...
http://peltiertech.com/Excel/Charts/...nColChart.html

**scubohuntr** · 01-17-2007, 02:41 PM

Thanks, Carim! It works. It's a little problematic for putting two constants on one chart, but I can get around that. Those charts are probably too busy anyway.