Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
CarlSprake
 
Posts: n/a
Default Click on chart to view it otherwise greyed out

I have been sent a workbook that contains a number of charts. when the
workbook opens the charts are not visible, but are "greyed out". I have to
click on a chart to view it. As soon as I click away from the chart it is
hidden again.

The source data is created using the offset function and the parameters for
this function are selected using form combo boxes.

Please can anyone suggest how I can make the charts visible at all times

Thanks

Carl
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

Sounds like you have objects set to show place holders.
To show all use the menu Tools Options. On the View tab is a section
for Objects. Check the Show all option.

Cheers
Andy

CarlSprake wrote:
I have been sent a workbook that contains a number of charts. when the
workbook opens the charts are not visible, but are "greyed out". I have to
click on a chart to view it. As soon as I click away from the chart it is
hidden again.

The source data is created using the offset function and the parameters for
this function are selected using form combo boxes.

Please can anyone suggest how I can make the charts visible at all times

Thanks

Carl


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
CarlSprake
 
Posts: n/a
Default

Thank You very much Andy

So simple when you know how! :- )

"Andy Pope" wrote:

Hi,

Sounds like you have objects set to show place holders.
To show all use the menu Tools Options. On the View tab is a section
for Objects. Check the Show all option.

Cheers
Andy

CarlSprake wrote:
I have been sent a workbook that contains a number of charts. when the
workbook opens the charts are not visible, but are "greyed out". I have to
click on a chart to view it. As soon as I click away from the chart it is
hidden again.

The source data is created using the offset function and the parameters for
this function are selected using form combo boxes.

Please can anyone suggest how I can make the charts visible at all times

Thanks

Carl


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,814
Default Click on chart to view it otherwise greyed out

Thank you Thank You Thank You....
This is a great tool .....your are llife savers...
Steve

"Andy Pope" wrote:

Hi,

Sounds like you have objects set to show place holders.
To show all use the menu Tools Options. On the View tab is a section
for Objects. Check the Show all option.

Cheers
Andy

CarlSprake wrote:
I have been sent a workbook that contains a number of charts. when the
workbook opens the charts are not visible, but are "greyed out". I have to
click on a chart to view it. As soon as I click away from the chart it is
hidden again.

The source data is created using the offset function and the parameters for
this function are selected using form combo boxes.

Please can anyone suggest how I can make the charts visible at all times

Thanks

Carl


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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
Undoing LINKS in Excel 2000 jayceejay New Users to Excel 3 January 4th 05 06:58 PM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 06:54 PM
Impedding/Overlaying Charts Phil Hageman Charts and Charting in Excel 4 December 17th 04 08:25 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 06:49 PM


All times are GMT +1. The time now is 02:57 PM.

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

About Us

"It's about Microsoft Excel"