Is it possible to chart one data series as a line and another as a bar on the
same graph. Other tools allow this and I have been asked to do it - I dont
see how it is possible since you define the graph as either line or bar to

Yes, you can do that. Create your column chart. Then go to the chart
properties dialog. In the dialog go to the Data tab and edit the properties
of your trend data series. The "Edit chart value" dialog should pop up. In
this dialog go to the Appearance tab and select "Plot data as line".
You can also check the following KB article:
http://support.microsoft.com/kb/842422


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]