I am trying to create a single bar with a gradient from Red (bottom) to Green
(top). I then what to create a single horizontal line going accross the bar
at a particular point.

Any ideas? Thanks in advance.

Add horizontal line to chart

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

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"John" wrote in message
...
I am trying to create a single bar with a gradient from Red (bottom) to
Green
(top). I then what to create a single horizontal line going accross the
bar
at a particular point.

Any ideas? Thanks in advance.

I think you are actually describing a column chart. To get the gradient fill,
format series, fill pattern, select 2 colors, then choose desired colors and
fill pattern.

For the horizontal line, create a dummy series with good endpoints (this
depends on whether your x-axis is category or series). If series, simply
select the start and stop, and give it a single value, then plot as a line.

If a category axis is being used, use a similar process to previous, but
move series to secondary axis. Hide 2nd y-axis, and format 2nd x-axis to
display no labels or tick marks.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"John" wrote:

I am trying to create a single bar with a gradient from Red (bottom) to Green
(top). I then what to create a single horizontal line going accross the bar
at a particular point.

Any ideas? Thanks in advance.