Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 29th 10, 10:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 73
Default The Incredible Shrinking Chart

BACKGROUND: We are in the unfortunate situation of having some employees
still on Excel 2003/some upgraded to 2007. This will continue for at least
another 2-3 months. (Thousands of employees involved, so the upgrade just
has to take as long as it takes.)

PROBLEM: Have a workbook with macros and a chart imbedded on worksheet #1,
saved as .xls for (we thought) useability by everybody. When a 2007 person
opens this file and saves it, he gets a warning about losing some fidelity,
but the text of the warning says nothing about charts or zoom level.
However, the next time that file is opened, the chart has shrunk by about
50%; repeat the process and it shrinks another 50%, etc., etc., until it's
just a black dot For the 2007 users we've figured out we can prevent this
by saving it as .xlsm, but that doesn't help the 2003 users.

QUESTION: until we get everybody upgraded, does anyone have a possible
explanation and suggestion about some exotic 2007 setting that can be changed
to prevent this?

  #2   Report Post  
Old March 29th 10, 11:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2010
Posts: 226
Default The Incredible Shrinking Chart

try this:

<http://www.microsoft.com/downloads/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

if it wraps, here's a tinyurl

http://tinyurl.com/ykums3
--


Gary Keramidas
Excel 2003


"LarryP" wrote in message
...
BACKGROUND: We are in the unfortunate situation of having some employees
still on Excel 2003/some upgraded to 2007. This will continue for at
least
another 2-3 months. (Thousands of employees involved, so the upgrade just
has to take as long as it takes.)

PROBLEM: Have a workbook with macros and a chart imbedded on worksheet
#1,
saved as .xls for (we thought) useability by everybody. When a 2007
person
opens this file and saves it, he gets a warning about losing some
fidelity,
but the text of the warning says nothing about charts or zoom level.
However, the next time that file is opened, the chart has shrunk by about
50%; repeat the process and it shrinks another 50%, etc., etc., until it's
just a black dot For the 2007 users we've figured out we can prevent
this
by saving it as .xlsm, but that doesn't help the 2003 users.

QUESTION: until we get everybody upgraded, does anyone have a possible
explanation and suggestion about some exotic 2007 setting that can be
changed
to prevent this?




Reply
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
Chart series legend font size keeps shrinking - how to stop it? IanQa Charts and Charting in Excel 0 February 4th 10 08:49 PM
How do I stop a small radar chart shrinking when I print/preview ZS1RA Charts and Charting in Excel 0 October 18th 09 06:54 PM
Growing/Shrinking/Selective Chart Data Rob Charts and Charting in Excel 12 November 4th 08 02:32 PM
Chart.Export images are shrinking as I export more images Jared Charts and Charting in Excel 3 January 29th 08 03:23 AM
Shrinking Charts Neil Charts and Charting in Excel 0 February 14th 05 06:29 PM


All times are GMT +1. The time now is 08:54 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017