2645 Views 3 Replies Latest reply: Oct 3, 2010 2:17 PM by Badunit
I am assuming you have the dates in a header column (A) and the prices in column B and you are not using the scatter chart. The category charts (the non-scatter charts) don't really care what the x-axis data is, the x data are labels/categories and are all evenly spaced on the axis. If you chart one series, it will create some categories in the chart's x axis. If you then add another series to the chart, it will use the categories from the first series until it runs out of categories and then it will append a few more categories to the chart.
If all your tables use the same dates in the same rows, your data will appear correctly on the chart. This assumes that your dates are all firsts of the months. If you have randomly spaced dates, the scatter chart is the only way to chart it out correctly in time.
Alternatively, if you move your dates to column B and prices to column C (the X and Y data must all be in the data area of the table, not in a header) then use the scatter chart, it will plot them as you want them. The default for the scatter chart is to plot data points without connecting lines. You can connect the dots by selecting the chart, going to the chart inspector, and choosing straight or curved connecting lines. One problem you may run into is that the X axis might not all be the firsts of the months because the spacing between gridlines is determined by days, not months, and there are varying numbers of days in each month. It might be possible to get it that way but it can be difficult.
EDIT: I switched the order of preference of these two solutions to have the scatter chart as an alternative rather then the primary solution because the scatter chart x-axis labels can be difficult when it is dates.
Message was edited by: Badunit