G Guest Oct 9, 2007 #1 How do you insert a new option button on existing charts? Tried copy and paste but this did not work.
How do you insert a new option button on existing charts? Tried copy and paste but this did not work.
G Guest Oct 9, 2007 #2 Try using the option button via the Controls toolbar. Select the Option Button on the Controls toolbar and drag it onto your spreadsheet. The use copy and paste to add it to your chart.
Try using the option button via the Controls toolbar. Select the Option Button on the Controls toolbar and drag it onto your spreadsheet. The use copy and paste to add it to your chart.
J Jon Peltier Oct 9, 2007 #3 Copy-Paste works for me. Alternatively, display the Forms toolbar, click on the Option Button button, and draw a new control. - Jon
Copy-Paste works for me. Alternatively, display the Forms toolbar, click on the Option Button button, and draw a new control. - Jon
J Jon Peltier Oct 9, 2007 #4 You can't add a controls toolbox control to your chart. Best you can do is locate them both on the same worksheet. - Jon
You can't add a controls toolbox control to your chart. Best you can do is locate them both on the same worksheet. - Jon