Chart repeats data when printed pls help !

  • Thread starter Thread starter blewyn
  • Start date Start date
B

blewyn

I have a spreadsheet that consists of a long list of data on the left
with a simple x-y scatter chart on the right - both list and chart are
longer than one page, and therefore must be printed across several
pages.

When I print the spreadsheet, the chart on each page prints the first
two rows of data from the beginning of the chart, so for example if
the data runs from 1-100, the first page chart printout shows 1-20,
the second page shows 1-2 then 13-20, the third page shows 1-2 then
23-30.

Could it be something to do with excel printing out the x axis on each
page, given that the x axis is set to cross the y axis at a specified
value ? (tried blanking this box but no change)

Any ideas ?

Thanks,

Blewyn
 
You may have accidentally set this up via :-
File/Page Setup/Sheet/"rows to repeat at top"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

charts look different if you put in data into the x axis 3
Chart with 2 sets of data 1
VBA Code to Export Data from Chart 4
charting variable line data 1
Printing Excel 2007 Chart 2
Replacing numeric X-axis labels with corresponding text string 2
Creating a chart with varying data value ranges 1
making charts 4

Back
Top