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" <KnockOffNigel[ at ]discussions.microsoft.com> wrote in message
news:DDBB47AB-F1B8-4AB4-B121-A7D370D15B54[ at ]microsoft.com...
[Quoted Text] > 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!
|