Charts

N

niborneslo

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

Debra Dalgleish

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.
 
T

Tushar Mehta

How can I create a chart that shows two sets of data over time, one in
columns, the other in a superimposed line?
Click to expand...
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Ways to create a budget chart for money managment 1
How to create a bubble chart with more than 2 variables. 0
Superimpose one Pipeline chart over another 1
Move Chart with Text 0
How to change series plotting order without changing legend order? 6
Superimpose one chart on another 1
Emphasize one Line on Horizontal Axis of Bar chart 5

Top