2 line one bar graph

[Guest]

I need to create graph which has min and max target and actual data each month
I would like to show each target as a line and actual as bar I can get 2 bar and one line but not other way roun
thank
tina

 

[Frank Kabel]

Hi
have a look at the following sites for creating lines in your chart:
http://andypope.info/charts/averageline.htm
http://www.tushar-mehta.com/excel/charts/straight_lines/index.html
http://peltiertech.com/Excel/Charts/DummySeries.html#AddLine

--
Regards
Frank Kabel
Frankfurt, Germany

I need to create graph which has min and max target and actual data each month
I would like to show each target as a line and actual as bar I can

get 2 bar and one line but not other way round

 

[Jon Peltier]

Tina -

An easier way than Frank suggested is to make the chart with three line
series, then select the one you want to change, and choose Chart Type
from the Chart menu. Pick out the column style you want.

- Jon