Charts with variable axes and series
I am trying to generate a chart that has drop down menus to select what is displayed on the x and y axes and a set of check boxes to control what data series are displayed. This will be part of a template spread sheet that will allow the user to paste raw data into it and have all the pertinent data displayed in the chart. The x-axis needs to have 3 different options while the y-axis needs as many as 21. I would like the names of the series (part of the raw data) to be displayed automatically in the check boxes that control which data series are displayed. What would be the most straightforward wayto accomplish this?
Many thanks in advance.
Assuming you are using controls from the Forms toolbox you could use a label and checkbox and link both to cells.
You need to use a label as the checkbox link will place TRUE/FALSE in the linked cells.
Edit the checkbox so it has no text.
Select the label and then enter the cell reference in the formula bar.
You can even group the 2 controls if you want.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks