2 line one bar graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

tina said:
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
Click to expand...
get 2 bar and one line but not other way round
 
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
 
Back
Top