
08-13-2008, 09:34 AM
|
|
Registered User
|
|
Join Date: 13 Aug 2008
Location: Sydney
Posts: 1
|
|
|
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..
|