How can I create a chart that shows two sets of data over time, one in
columns, the other in a superimposed line?

Jon Peltier give some good examples of charts on his site. Look at
www.peltiertech.com

"niborneslo" wrote in message
...
How can I create a chart that shows two sets of data over time, one in
columns, the other in a superimposed line?

Create a column chart from all the data.
Right-click on the series that you want as a line
Choose Chart Type
Select the Line chart type, and one of the subtypes
Click OK.

niborneslo wrote:
How can I create a chart that shows two sets of data over time, one in
columns, the other in a superimposed line?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

In article ,
says...
How can I create a chart that shows two sets of data over time, one in
columns, the other in a superimposed line?

Create, say, a column chart with both data sets. Then, in the chart,
select the series you want to be a line and select Chart | Chart
Type... and the appropriate line + sub-type option.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions