View Single Post
  #1  
Old 08-13-2008, 09:34 AM
razi812 razi812 is offline
Registered User
 
Join Date: 13 Aug 2008
Location: Sydney
Posts: 1
razi812 is an unknown quantity at this point
Charts on the Move...

G'day frienz...

Can anyone give any advice on this pleazze ! !

I have created a spread sheet of reports comprisng of data, bar charts and pie charts.

Each report is mapped out across the sheet for 6 pages, 4 of which have the bar charts and pie charts. On each of the 4 pages there are 3 bar & 3 pie. Total charts for each report is 12 bar n 12 pie.

At the moment I have 20 reports. 6 pages across for 1, then 19 others below the first one. The reports are the same except for different data values which give different readings on the charts.

The probem is:
When I print out a report or look in the print review which is the same as what is about to be printed, the charts have moved slightly.

The movement of the charts only but not the data, start at the very first chart but can only be be seen minimaly. The charts are moving down and slightly to the right, by the 3/4 mark and particularly at the end of the sheet or charted area, they have moved over the thickness of 1 cell and by small incriments at a time.

# Sample of 1 report + 19 below this one. ( = ) bar graph ( O ) pie chart

Pages:
.......1......2......3.......4......5......6
_______________________________
| data| = O | = O | = O | = O |data |
| data| = O | = O | = O | = O |data |
| data| = O | = O | = O | = O |data |
_______________________________

I have looked, searched and tried fo hours and now days on end to find out why ths is happening. I understand this may only be a setting somewhere or a minor adjustment, but I don't know ! !

Has anyone got any clues or an answer Pleazze ! !

Last edited by razi812; 08-13-2008 at 09:55 AM..
Reply With Quote