cancel
Showing results for 
Search instead for 
Did you mean: 

Use of radio buttons in xcelsius

Former Member
0 Kudos

Hi,

I have a requirement where user will be provided with a radio button to hide/ unhide certain columns of a table for which the source data will be in the excel worksheet.

For example: Show Description? OYes ONo

and based on the user input columns will be shown in the report.

How can I implement this with the help of xcelsius?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Use the radiobutton control and copy a range to a specific area on change (see the first data tab, the large white field). Then have a chart on the specific area and it will show the data you want to see based on whats copied in by the radiobutton.

Former Member
0 Kudos

Hi Roeland,

can you explain in detail what exactly needs to be done?

'copy a range to a specific area on change (see the first data tab, the large white field). '

I am assuming 'The large white field' you have mentioned is 'Data Insertion' in 'General tab'

This section contains Series. I have created two series 1. Yes 2. No

Now what will be the 'Insertion Type' value so that if I select 'Yes' then 4 columns will be copied and for 'No' 2 columns will be copied.