A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Weard problem with formatting of charts in Excel 2007



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2009, 05:24 PM posted to microsoft.public.excel.misc
Rolando
external usenet poster
 
Posts: 32
Default Weard problem with formatting of charts in Excel 2007

One workbook with 5 sheets with each different charts, Excel 2007, Wind XP.
One of the 5 charts is not shown when the workbook is opened unless a
preview is performed,... and even then the format is changed since the
original and objects in chart can not be changed.
On a second PC, also in Excel 2007-Win XP, this problem is not encountered,
all graphs are as original format.
I contacted Microsoft for this problem but they claim problems with the
printer driver (HP). I also contacted HP for this problem but they claim
problems with Office Excel.
Has enyone encountered this problem also ?
  #2  
Old May 14th, 2009, 06:28 PM posted to microsoft.public.excel.misc
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Weard problem with formatting of charts in Excel 2007

Seems to me a printer driver would affect all charts.

Was the bad chart (or the good charts) created in an earlier version of
Excel? I haven't experienced problems like this firsthand, but I've heard
from folks who have had issues related to crossing versions.

Unfortunately your more robust means of recovery may be to rebuild the
workbook and charts.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
One workbook with 5 sheets with each different charts, Excel 2007, Wind
XP.
One of the 5 charts is not shown when the workbook is opened unless a
preview is performed,... and even then the format is changed since the
original and objects in chart can not be changed.
On a second PC, also in Excel 2007-Win XP, this problem is not
encountered,
all graphs are as original format.
I contacted Microsoft for this problem but they claim problems with the
printer driver (HP). I also contacted HP for this problem but they claim
problems with Office Excel.
Has enyone encountered this problem also ?



  #3  
Old May 14th, 2009, 08:11 PM posted to microsoft.public.excel.misc
Rolando
external usenet poster
 
Posts: 32
Default Weard problem with formatting of charts in Excel 2007

thanx Jon
graphs were indeed created by the 2000 version.
but you're right, I need to rebuild the graph from scratch
hpe this might solve
roland

"Jon Peltier" wrote:

Seems to me a printer driver would affect all charts.

Was the bad chart (or the good charts) created in an earlier version of
Excel? I haven't experienced problems like this firsthand, but I've heard
from folks who have had issues related to crossing versions.

Unfortunately your more robust means of recovery may be to rebuild the
workbook and charts.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
One workbook with 5 sheets with each different charts, Excel 2007, Wind
XP.
One of the 5 charts is not shown when the workbook is opened unless a
preview is performed,... and even then the format is changed since the
original and objects in chart can not be changed.
On a second PC, also in Excel 2007-Win XP, this problem is not
encountered,
all graphs are as original format.
I contacted Microsoft for this problem but they claim problems with the
printer driver (HP). I also contacted HP for this problem but they claim
problems with Office Excel.
Has enyone encountered this problem also ?




  #4  
Old May 15th, 2009, 08:20 PM posted to microsoft.public.excel.misc
Rolando
external usenet poster
 
Posts: 32
Default Weard problem with formatting of charts in Excel 2007

Dear Jon
I have created a new chart from scratch in Excel 2007
believe it or not, the same problem shows up !
chart isn't showed unless 'preview' selected, and formats are changed !
I can't believe this !
regards
roland

"Rolando" wrote:

thanx Jon
graphs were indeed created by the 2000 version.
but you're right, I need to rebuild the graph from scratch
hpe this might solve
roland

"Jon Peltier" wrote:

Seems to me a printer driver would affect all charts.

Was the bad chart (or the good charts) created in an earlier version of
Excel? I haven't experienced problems like this firsthand, but I've heard
from folks who have had issues related to crossing versions.

Unfortunately your more robust means of recovery may be to rebuild the
workbook and charts.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
One workbook with 5 sheets with each different charts, Excel 2007, Wind
XP.
One of the 5 charts is not shown when the workbook is opened unless a
preview is performed,... and even then the format is changed since the
original and objects in chart can not be changed.
On a second PC, also in Excel 2007-Win XP, this problem is not
encountered,
all graphs are as original format.
I contacted Microsoft for this problem but they claim problems with the
printer driver (HP). I also contacted HP for this problem but they claim
problems with Office Excel.
Has enyone encountered this problem also ?




  #5  
Old May 16th, 2009, 06:27 PM posted to microsoft.public.excel.misc
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Weard problem with formatting of charts in Excel 2007

Did you start from a whole new worksheet or workbook?

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
Dear Jon
I have created a new chart from scratch in Excel 2007
believe it or not, the same problem shows up !
chart isn't showed unless 'preview' selected, and formats are changed !
I can't believe this !
regards
roland

"Rolando" wrote:

thanx Jon
graphs were indeed created by the 2000 version.
but you're right, I need to rebuild the graph from scratch
hpe this might solve
roland

"Jon Peltier" wrote:

Seems to me a printer driver would affect all charts.

Was the bad chart (or the good charts) created in an earlier version of
Excel? I haven't experienced problems like this firsthand, but I've
heard
from folks who have had issues related to crossing versions.

Unfortunately your more robust means of recovery may be to rebuild the
workbook and charts.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
One workbook with 5 sheets with each different charts, Excel 2007,
Wind
XP.
One of the 5 charts is not shown when the workbook is opened unless a
preview is performed,... and even then the format is changed since
the
original and objects in chart can not be changed.
On a second PC, also in Excel 2007-Win XP, this problem is not
encountered,
all graphs are as original format.
I contacted Microsoft for this problem but they claim problems with
the
printer driver (HP). I also contacted HP for this problem but they
claim
problems with Office Excel.
Has enyone encountered this problem also ?





  #6  
Old May 16th, 2009, 09:24 PM posted to microsoft.public.excel.misc
Rolando
external usenet poster
 
Posts: 32
Default Weard problem with formatting of charts in Excel 2007

Dear Jon
I found where the problem lies
suppose a chart with 2 line series (further S1 and S2)
S1 is referenced to the 1st vertical axis (V1), S2 to the 2nd vertical axis
(V2), so far OK
I added 2 series which represent the average of all timepoints in S1 and S2
(further A1 and A2.
I want the averages to be referenced to their respective axis, meaning A1
ref to axis V1, A2 to axis V2 and also to be located at the end of series,
meaning @ the last datapoint
To perform the fiirst action, when I reference both A1 and A2 to their
respective V1 and V2, no problem
To perform 2n action, I changed A1's chart type to XY scatter, OK,
BUT from the moment I change the chart type of A2 to XYScatter, the problems
comes in.
When I save the file and reopen the chart doen's showup unless preview,
resulting in changed formts AND S2 disappeared !
any suggestions ?

"Jon Peltier" wrote:

Did you start from a whole new worksheet or workbook?

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
Dear Jon
I have created a new chart from scratch in Excel 2007
believe it or not, the same problem shows up !
chart isn't showed unless 'preview' selected, and formats are changed !
I can't believe this !
regards
roland

"Rolando" wrote:

thanx Jon
graphs were indeed created by the 2000 version.
but you're right, I need to rebuild the graph from scratch
hpe this might solve
roland

"Jon Peltier" wrote:

Seems to me a printer driver would affect all charts.

Was the bad chart (or the good charts) created in an earlier version of
Excel? I haven't experienced problems like this firsthand, but I've
heard
from folks who have had issues related to crossing versions.

Unfortunately your more robust means of recovery may be to rebuild the
workbook and charts.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
One workbook with 5 sheets with each different charts, Excel 2007,
Wind
XP.
One of the 5 charts is not shown when the workbook is opened unless a
preview is performed,... and even then the format is changed since
the
original and objects in chart can not be changed.
On a second PC, also in Excel 2007-Win XP, this problem is not
encountered,
all graphs are as original format.
I contacted Microsoft for this problem but they claim problems with
the
printer driver (HP). I also contacted HP for this problem but they
claim
problems with Office Excel.
Has enyone encountered this problem also ?






  #7  
Old May 17th, 2009, 02:54 AM posted to microsoft.public.excel.misc
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Weard problem with formatting of charts in Excel 2007

What are your X values? Are they dates?

What is the type of category axis? Category ("Text" in 2007) or date-scale?
If date-scale, what is the base unit?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Rolando" wrote in message
...
Dear Jon
I found where the problem lies
suppose a chart with 2 line series (further S1 and S2)
S1 is referenced to the 1st vertical axis (V1), S2 to the 2nd vertical
axis
(V2), so far OK
I added 2 series which represent the average of all timepoints in S1 and
S2
(further A1 and A2.
I want the averages to be referenced to their respective axis, meaning A1
ref to axis V1, A2 to axis V2 and also to be located at the end of series,
meaning @ the last datapoint
To perform the fiirst action, when I reference both A1 and A2 to their
respective V1 and V2, no problem
To perform 2n action, I changed A1's chart type to XY scatter, OK,
BUT from the moment I change the chart type of A2 to XYScatter, the
problems
comes in.
When I save the file and reopen the chart doen's showup unless preview,
resulting in changed formts AND S2 disappeared !
any suggestions ?

"Jon Peltier" wrote:

Did you start from a whole new worksheet or workbook?

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
Dear Jon
I have created a new chart from scratch in Excel 2007
believe it or not, the same problem shows up !
chart isn't showed unless 'preview' selected, and formats are changed !
I can't believe this !
regards
roland

"Rolando" wrote:

thanx Jon
graphs were indeed created by the 2000 version.
but you're right, I need to rebuild the graph from scratch
hpe this might solve
roland

"Jon Peltier" wrote:

Seems to me a printer driver would affect all charts.

Was the bad chart (or the good charts) created in an earlier version
of
Excel? I haven't experienced problems like this firsthand, but I've
heard
from folks who have had issues related to crossing versions.

Unfortunately your more robust means of recovery may be to rebuild
the
workbook and charts.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and
Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
One workbook with 5 sheets with each different charts, Excel 2007,
Wind
XP.
One of the 5 charts is not shown when the workbook is opened
unless a
preview is performed,... and even then the format is changed since
the
original and objects in chart can not be changed.
On a second PC, also in Excel 2007-Win XP, this problem is not
encountered,
all graphs are as original format.
I contacted Microsoft for this problem but they claim problems
with
the
printer driver (HP). I also contacted HP for this problem but they
claim
problems with Office Excel.
Has enyone encountered this problem also ?








  #8  
Old May 17th, 2009, 10:08 AM posted to microsoft.public.excel.misc
Rolando
external usenet poster
 
Posts: 32
Default Weard problem with formatting of charts in Excel 2007

Jon
X values are contineous number values
Category axis is text bud represent dates in textform
However, when graphs construsted in new workbook with series as numbers and
no category axis type selected (thus represent sample numbers), the same
problem occurs.

"Jon Peltier" wrote:

What are your X values? Are they dates?

What is the type of category axis? Category ("Text" in 2007) or date-scale?
If date-scale, what is the base unit?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Rolando" wrote in message
...
Dear Jon
I found where the problem lies
suppose a chart with 2 line series (further S1 and S2)
S1 is referenced to the 1st vertical axis (V1), S2 to the 2nd vertical
axis
(V2), so far OK
I added 2 series which represent the average of all timepoints in S1 and
S2
(further A1 and A2.
I want the averages to be referenced to their respective axis, meaning A1
ref to axis V1, A2 to axis V2 and also to be located at the end of series,
meaning @ the last datapoint
To perform the fiirst action, when I reference both A1 and A2 to their
respective V1 and V2, no problem
To perform 2n action, I changed A1's chart type to XY scatter, OK,
BUT from the moment I change the chart type of A2 to XYScatter, the
problems
comes in.
When I save the file and reopen the chart doen's showup unless preview,
resulting in changed formts AND S2 disappeared !
any suggestions ?

"Jon Peltier" wrote:

Did you start from a whole new worksheet or workbook?

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
Dear Jon
I have created a new chart from scratch in Excel 2007
believe it or not, the same problem shows up !
chart isn't showed unless 'preview' selected, and formats are changed !
I can't believe this !
regards
roland

"Rolando" wrote:

thanx Jon
graphs were indeed created by the 2000 version.
but you're right, I need to rebuild the graph from scratch
hpe this might solve
roland

"Jon Peltier" wrote:

Seems to me a printer driver would affect all charts.

Was the bad chart (or the good charts) created in an earlier version
of
Excel? I haven't experienced problems like this firsthand, but I've
heard
from folks who have had issues related to crossing versions.

Unfortunately your more robust means of recovery may be to rebuild
the
workbook and charts.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and
Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Rolando" wrote in message
...
One workbook with 5 sheets with each different charts, Excel 2007,
Wind
XP.
One of the 5 charts is not shown when the workbook is opened
unless a
preview is performed,... and even then the format is changed since
the
original and objects in chart can not be changed.
On a second PC, also in Excel 2007-Win XP, this problem is not
encountered,
all graphs are as original format.
I contacted Microsoft for this problem but they claim problems
with
the
printer driver (HP). I also contacted HP for this problem but they
claim
problems with Office Excel.
Has enyone encountered this problem also ?









 




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:05 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.