Chart question
Hi,
I have two charts and would like only one of them to be visible at anuy one time. They occupy the same area of the screen and would like to add a button or two to toggle them on or off. I have run a macro which selects one of the charts and then use Send to Back. However when attaching the code from this macro to the button I get an error. Can anyone help? Thanks, Matt |
Chart question
This will toggle hiding/unhiding a chart
Sub hideunhidechart() Sheets("Sheet5").ChartObjects("Chart 1").Visible = _ Not Sheets("Sheet5").ChartObjects("Chart 1").Visible End Sub -- Don Guillett SalesAid Software "Matt" wrote in message ... Hi, I have two charts and would like only one of them to be visible at anuy one time. They occupy the same area of the screen and would like to add a button or two to toggle them on or off. I have run a macro which selects one of the charts and then use Send to Back. However when attaching the code from this macro to the button I get an error. Can anyone help? Thanks, Matt |
Chart question
Matt -
On this page I show how to select which chart to show based on a selection from a combo box or list box (the second example): http://www.geocities.com/jonpeltier/...eDropDown.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Matt wrote: Hi, I have two charts and would like only one of them to be visible at anuy one time. They occupy the same area of the screen and would like to add a button or two to toggle them on or off. I have run a macro which selects one of the charts and then use Send to Back. However when attaching the code from this macro to the button I get an error. Can anyone help? Thanks, Matt |
All times are GMT +1. The time now is 05:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com