Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2709 point limit in Excel 2007 scatter plot
It appears that I cannot print a line-only scatter plot with more than 2709
points in the series. In a new workbook, I filled column A with "=row()" and column B with "=sin(0.01*a1)". The chart appears correctly on the screen and in the print preview, however printing to an HP printer (tried both laserjet 6 and deskjet 6100 series) or Adobe 9 PDF driver results in a chart with axes and legend but no data. If I change the range to 2709 points or less, the chart prints properly. If I format the plot to include markers, it prints properly. The system I'm using has both Excel 2003 and 2007 on it. I can save the file as either a .xls or .xlsx file and open the file in Excel 2003. The chart prints properly in this version of Excel. I tried to reproduce the problem on a another computer, which did NOT have Excel 2003 installed, and the problem does not appear. There are multiple differences between the two systems however, so I cannot determine if this is correlation or coincidence. I am very hesitant to uninstall Excel 2003 on my main computer, since 2007 continues to present minor glitches like this one that make life difficult. Any comments/suggestions would be welcome. Regards, Vivianne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Point labels in an Excel scatter plot to be associated text | Charts and Charting in Excel | |||
Scatter Plot Point Labels | Excel Worksheet Functions | |||
scatter plot data point labelling question | Charts and Charting in Excel | |||
Retrieve point address from scatter plot by clicking? | Charts and Charting in Excel | |||
scatter plot & label for a data point | Charts and Charting in Excel |