Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel bounding boxes on chart data sources | Charts and Charting in Excel | |||
Pivottables - Can i consolidate 2 Data sources in Excel 2007? | Excel Discussion (Misc queries) | |||
Excel 2007 and External Data Sources | Excel Discussion (Misc queries) | |||
Connection to external data sources in Excel | Excel Discussion (Misc queries) | |||
Two Excel Data Sources | Excel Discussion (Misc queries) |