line column chart

[hiddennchrist]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

My teacher asked me to make a line/column chart. It looks to me like I can only do either/or, how do I put both on one? He showed us how to do it in the 2003 version, but I can't find a free download. I have the 2008 version.
~ Jennifer

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

My teacher asked me to make a line/column chart. It looks to me like I can
only do either/or, how do I put both on one? He showed us how to do it in the
2003 version, but I can't find a free download. I have the 2008 version.
~ Jennifer

OK, what exactly did he show you how to do?

 

[Mike Middleton]

hiddennchrist or Jennifer -

Here's one way: Enter two columns of data on a worksheet. Select the data
range. In Mac Excel 2008, choose Insert | Chart | Column | Clustered Column
(the leftmost icon). Click a bar on the chart to select the data series you
want to change from Column to Line. Choose Insert | Chart | Line | Line (the
leftmost icon). Done.

If you have another column of data that you want to use to label the
Horizontal (Category) Axis, select any chart object, and choose Chart |
Source Data, and specify the data range for Category (X) Axis Labels.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel