Add second string of data to existing chart

L

Lori

Excel 2007
I have a chart with one line of data, about 7 points. The source data is in
c7:k7. I want to add a second line of data with source c8:k8. When I do, it
creates a second line as an sum total of point 1 (rows 7 and 8). I am using
chart tools, design, select data. I have used the interactive guide with no
success.
 
A

Andy Pope

Hi,

Sounds like the chart type you have is Stacked Line rather than a normal
line chart.
So you need to change the chart type. Chart Tools > Design . Change Chart
Type.

Cheers
Andy
 

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

Add average data horizontally into existing chart 2
Finding second data point on primary axis of two axis chart 1
Problem with line Chart 2
Adding Additional Points to a Line Chart 7
Problem w/X axis in chart (2003) 3
Chart Source Data 5
Adding a second series to an existing chart 4
Showing totals in data table in a line chart 3

Top