View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Bar and Line graph combi?

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" wrote in message
...
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?