Thread: Charts

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" <niborneslo@discussions.microsoft.com> wrote in message
news:FE1151F0-E6F5-493A-B00A-68843C776B63@microsoft.com...
> 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 <FE1151F0-E6F5-493A-B00A-68843C776B63@microsoft.com>,
niborneslo@discussions.microsoft.com 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