3 bars (1st Y axis) 1 line (2nd Y axis) please help!!!!!

[Guest]

I need to make a chart with 3 bars (profit), and a line (money lost %), i could make it with 2 bars, but i dont know if it possible to add 1 bar!!!!
Please Help!!!!!!
KARLA

 

[Debra Dalgleish]

Make a bar chart with all the data.
Right-click on the series that you want as a line.
Choose Chart Type
Select Line category, and one of the subtypes
Click OK

Jon Peltier has information on creating your own combination charts:


http://www.geocities.com/jonpeltier/Excel/Charts/ComboCharts.html#ComboCht

 

[Tushar Mehta]

Make a column chart with all the data series of interest. Then, select
the column on the chart that you want as a line. With it selected,
select Chart | Chart Type... | and the Line + subtype of your choice.
Double-click the line series in the chart and from the Axis tab select
Secondary.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office