| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Avoid Printing the Combo Box with the Chart
I have a chart sheet with a combo box which I use to select the county
I'm interesting in plotting. My question for the group - is there a way to keep the combo box from printing with the chart? Perhaps what I need to do is simply create the chart on a worksheet and print it from there. Just thought I would ask. Its not critical, but I thought it would look nicer if I could leave the combo box off. I wanted to use the chart sheet just to keep things "cleaner". Mike |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Avoid Printing the Combo Box with the Chart
Hi,
Right click the combo box and on the properties tab uncheck the Print Object. Cheers Andy wrote: I have a chart sheet with a combo box which I use to select the county I'm interesting in plotting. My question for the group - is there a way to keep the combo box from printing with the chart? Perhaps what I need to do is simply create the chart on a worksheet and print it from there. Just thought I would ask. Its not critical, but I thought it would look nicer if I could leave the combo box off. I wanted to use the chart sheet just to keep things "cleaner". Mike -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Avoid Printing the Combo Box with the Chart
You're Awesome! Thank you very much!
Andy Pope wrote: Hi, Right click the combo box and on the properties tab uncheck the Print Object. Cheers Andy wrote: I have a chart sheet with a combo box which I use to select the county I'm interesting in plotting. My question for the group - is there a way to keep the combo box from printing with the chart? Perhaps what I need to do is simply create the chart on a worksheet and print it from there. Just thought I would ask. Its not critical, but I thought it would look nicer if I could leave the combo box off. I wanted to use the chart sheet just to keep things "cleaner". Mike -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting values in a bar chart | Charts and Charting in Excel | |||
| How to avoid when linked source data is changed, chart turns blan. | Charts and Charting in Excel | |||
| Line Chart - 2 | Charts and Charting in Excel | |||
| Pivot Chart - default chart type | Excel Discussion (Misc queries) | |||
| combo chart | Charts and Charting in Excel | |||
Linear Mode
