Excel Data Sources

K

KnockOffNigel

Excel 2007

I have created a standard line chart, which I hoped to represent two
different data sets on (x-axis = time, y-axis = %).

Data Series 1 plots perfectly.
Data Series 2, instead of plotting the second data series, plots Data Series
1 + Data Series 2 (added together). When you add data labelling, it states
the % as the correct value, i.e. it says 7.26% but plots the point 5% (-2.26%
+7.26%).


Rather confused, I cannot determine what I am doing wrong. I'd suggest a
fundamental error with excel, but that seems ridiculous. Please help!
 
D

David Biddulph

I suggest that you go back and look carefully at what sub-type of line chart
you have chosen. My guess is that you have chosen a "stacked" chart.
Choose a line chart other than stacked, or if you are trying to plot your Y
values against your X values you may find that XY (confusing described as
"scatter") is the right chart type.
 

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

Data points in chart incorrect 0
Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1
2nd axis plotting incorrectly - is there a chart size limit? 2
adding trendline to plots from multiple series 1
Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
vertical scale on both ends of bar chart 1
Assign data series to primary axis 1
multiple series bar and line chart 2

Top