LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Point labels in an Excel scatter plot to be associated text Point labels in scatter plot - text? Charts and Charting in Excel 4 April 29th 23 07:45 PM
Scatter Plot Point Labels Dallas Excel Worksheet Functions 2 December 5th 07 03:24 PM
scatter plot data point labelling question Bob Christensen 3 Charts and Charting in Excel 5 November 16th 07 04:55 PM
Retrieve point address from scatter plot by clicking? Jdoggrr Charts and Charting in Excel 3 October 21st 05 02:02 PM
scatter plot & label for a data point shabnam Charts and Charting in Excel 3 April 11th 05 06:37 PM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"