Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Undoing LINKS in Excel 2000 | New Users to Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
Impedding/Overlaying Charts | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |