I am currently getting my blood tested every two weeks and have made a
simple 3d column chart with the data.

This shows the results well.

However i would like a red line showing the maximum and minimum levels
that would show the "Normal" parameters of the blood.

For instance the column for this week rises to 11.5 and the top and
bottom (Normal) parameters are 13.5 to 18 so I would like a line at
13.5 and one at 18 with my column of 11.5 over the lines.

Hope this is clear as this is one of my first attempts at charting.


--
thepict@albaweb
------------------------------------------------------------------------
thepict@albaweb's Profile: http://www.excelforum.com/member.php...o&userid=33469
View this thread: http://www.excelforum.com/showthread...hreadid=532718

Hi,

To add datum lines to a chart you will need to use a 2d column chart.
Then have a look at the following pages for examples of how to add lines.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

Cheers
Andy

thepict@albaweb wrote:
I am currently getting my blood tested every two weeks and have made a
simple 3d column chart with the data.

This shows the results well.

However i would like a red line showing the maximum and minimum levels
that would show the "Normal" parameters of the blood.

For instance the column for this week rises to 11.5 and the top and
bottom (Normal) parameters are 13.5 to 18 so I would like a line at
13.5 and one at 18 with my column of 11.5 over the lines.

Hope this is clear as this is one of my first attempts at charting.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Many thanks


--
thepict@albaweb
------------------------------------------------------------------------
thepict@albaweb's Profile: http://www.excelforum.com/member.php...o&userid=33469
View this thread: http://www.excelforum.com/showthread...hreadid=532718