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