Hello.
I have a sheet containing measured data. The data is in 6 different columns.
I have a chart displaying the measured data from the first column.
I would like to have only one chart and 6 radio buttons where you can chose which column to get data from.
Is this possible? By doing this I save a lot of space in my worksheet.
Can someone please help?
/Anders
The code below was done via the macro recorder. You need one for each button desired:
Please Login or Register to view this content.
Note that this code assumes you have already created your chart.
Last edited by protonLeah; 10-19-2008 at 01:55 PM. Reason: added note
Ben Van Johnson
You can use the INDEX formula to populate a single series that is charted without the use of code.
That's fantastic and exactly what I need.Originally Posted by Andy Pope
Please tell me how you set up the radio buttons to return a number.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks