PC Review


Reply
Thread Tools Rate Thread

2000/2003 Chart Not Visible In 2007!

 
 
victorcamp
Guest
Posts: n/a
 
      6th Sep 2007
I'm using Excel 2007 on Vista.

A worksheet with 3 charts (3 whole sheets) was created in Excel 2003. None
of the charts appear. Their sheets are there, but they're blank screens: no
background, no grid, no nothing. There are no active ribbon buttons while on
a chart sheet. I installed HotFix KB938538, but that didn't help. Still
nothing.

I asked for info via the Immediate Window. They all appear to still be
there! The Series', the Titles, the Legends. The data they reference is also
still there; and visible! The workbook has no external links.

What can I do to make them reappear?

Excel 2007 is the only version I have with which to maintain this client's
data. It might be possible to retrieve all the info I need to recreate them
via the Immediate Window, but that's a formidable task! I also know there
are some chart parts inaccessible to VB; e.g., the DataRange, and the
individual components of the Formula, like Values. (The Formula is
available!)

Any help?

 
Reply With Quote
 
 
 
 
victorcamp
Guest
Posts: n/a
 
      6th Sep 2007
DEFAULT PRINTER!

It turns out Excel 2007 needs a compatible printer specified as Default in
order to show charts. Since this laptop has never had a printer connected to
it, it's Default Printer was who-knows-what. A Microsoft Tech made the
simple switch, and everything appeared! This is what he chose: Microsoft
Office Document Image Writer

Hooray!

"victorcamp" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> I'm using Excel 2007 on Vista.
>
> A worksheet with 3 charts (3 whole sheets) was created in Excel 2003. None
> of the charts appear. Their sheets are there, but they're blank screens:
> no
> background, no grid, no nothing. There are no active ribbon buttons while
> on
> a chart sheet. I installed HotFix KB938538, but that didn't help. Still
> nothing.
>
> I asked for info via the Immediate Window. They all appear to still be
> there! The Series', the Titles, the Legends. The data they reference is
> also
> still there; and visible! The workbook has no external links.
>
> What can I do to make them reappear?
>
> Excel 2007 is the only version I have with which to maintain this client's
> data. It might be possible to retrieve all the info I need to recreate
> them
> via the Immediate Window, but that's a formidable task! I also know there
> are some chart parts inaccessible to VB; e.g., the DataRange, and the
> individual components of the Formula, like Values. (The Formula is
> available!)
>
> Any help?
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make Excel 2007 chart sheets visible C. Varnavas Microsoft Excel Charting 1 25th Apr 2010 03:19 PM
Excel 2003 Chart Sheets that are not visible in 2007 Cben Microsoft Excel Crashes 0 13th Sep 2008 10:08 AM
2000/2003 Chart Not Visible In 2007! victorcamp Microsoft Excel Discussion 2 6th Sep 2007 11:04 PM
2000/2003 Chart Not Visible In 2007! victorcamp Microsoft Excel Charting 1 6th Sep 2007 09:59 PM
Excel 2003 Chart Labels Not Visible paul_cross@armtech.com Microsoft Excel Discussion 0 12th Oct 2005 06:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:22 PM.