Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Aligning lines in a chart
Hi
I have a chart created from three different worksheets. They are lists of defects grouped on dates, and each sheet contains one status. The x-axis has dates, the y-axis has number of defects. The problem seems to be aligning the different lines from these worksheets. The groups are not on the same dates, so I have three tables that can look like this (only first three, sorted): Date New Defects 27.05.2008 9 28.05.2008 14 29.05.2008 14 Date Fixed Defects 28.05.2008 7 29.05.2008 6 30.05.2008 8 Date Closed Defects 29.05.2008 1 02.06.2008 9 03.06.2008 3 So the lines in the chart does not align properly. Two of the lines end far right in the chart with no x-axis labels, for instance. See results he http://www.questus.no/Default.aspx?tabid=38 Especially notice the bottom right corner. How can I align these lines? How can I make sure the line values fall on correct dates along the x-axis? Any help appreciated. Regards, Rolf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aligning lines in a chart | Charts and Charting in Excel | |||
Combination chart - aligning column categories with time-scale x-a | Charts and Charting in Excel | |||
Aligning decimal numers to the centre of the cell and aligning dec | Excel Discussion (Misc queries) | |||
Aligning two chart plot areas - simple but tricky! | Charts and Charting in Excel | |||
Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel |