Working with Charts
I am new to VBA programming for Excel, and I need some help on how to
accomplish the following: I have an existing spreadsheet with 5 charts. I would like to create option buttons to allow the user to see one chart at a time. Currently all the charts are displayed on one worksheet, and various inputs in the workbook affect the charts. When I code Option Button Click, how do I manage to display the different charts for the different buttons. Any tips or suggestions would be greatly appreciated. |
Hi
Much depends on charts (are they similar or very different), but probably you can have a single chart, which datasource is modified accordingly the selection from data validation drop-down on sheet. You can : a) use a hidden table as datasource for chart - data in source table depends on selected option(s); b) use dynamic ranges as sources for series - range definitions depend on selected option(s); c) modify chart datasource (and/or chart type) through VBA code - with selected option(s) as parameters. You have to use a procedure or worksheet's Change event for this. -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "J. Stone" wrote in message om... I am new to VBA programming for Excel, and I need some help on how to accomplish the following: I have an existing spreadsheet with 5 charts. I would like to create option buttons to allow the user to see one chart at a time. Currently all the charts are displayed on one worksheet, and various inputs in the workbook affect the charts. When I code Option Button Click, how do I manage to display the different charts for the different buttons. Any tips or suggestions would be greatly appreciated. |
All times are GMT +1. The time now is 08:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com