View Single Post
  #3  
Old November 9th, 2009, 02:07 PM posted to microsoft.public.excel.charting
Luke M
external usenet poster
 
Posts: 2,672
Default Bar Graph with straight line

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.