Hi,
When trying to combine Bar and Line you need to use the XY-scatter rather
than the Line chart type.
This will allow you to specify both the X, value, position and more
importantly the Y, bar alignment, position.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"GD" <(E-Mail Removed)> wrote in message
news:CF429BF0-2D35-4AD5-A46B-(E-Mail Removed)...
> Hi, i'm being asked to present some 5 year forecast data, which
> historically
> has been broken down into monthly results represented on a bar chart.
> However
> the request has come in that they would like me to add a line representing
> a
> previous forecast, to compare accuracy - i'm struggling to incorperate a
> line
> to my bar-chart that has fixed value points and represents another series
> of
> data?