ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel 2007 Help

Notices

Reply
 
Thread Tools Search this Thread Display Modes
  #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 on a distinguished road
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
  #2  
Old 10-29-2008, 01:33 PM
tlspancap tlspancap is offline
Registered User
 
Join Date: 07 Oct 2008
Location: tennessee
Posts: 4
tlspancap is on a distinguished road
where you ever able to figure this out? i am having a similar problem, and cannot seem to find a solution. thanks!
Reply With Quote
Reply

Bookmarks

New topics in Excel 2007 Help


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


All times are GMT -4. The time now is 08:15 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0