on 09-09-2010 12:57 PM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.