View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
KnockOffNigel KnockOffNigel is offline
external usenet poster
 
Posts: 1
Default 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!