Excel Data Sources
 

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!

Excel Data Sources
 

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.
--
David Biddulph

"KnockOffNigel" wrote in message
...
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!