Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Add second string of data to existing chart
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Add second string of data to existing chart
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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Lori" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar width on existing chart changes when changing source data | Charts and Charting in Excel | |||
Insert New Data in Order on an Existing Chart | Excel Discussion (Misc queries) | |||
Copying a chart and data to existing worksheet | Charts and Charting in Excel | |||
Add source data to an existing chart? | Charts and Charting in Excel | |||
How To: Link worksheet data to pre-existing chart tables | Charts and Charting in Excel |