Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my report i have a chart ,with 3 expressions and i applied a fast change option for bar chart and straight table.In which i want to show the 3 expressions in the straight table and when we change to bar chart i want to hide one of the expression .Is it possible ?Please check the screen shot.
Hi Polisetti
In the expressions tab in the chart properties, highlight the expression that you wish to hide in the bar chart, and set it to "invisible" (check box to the right of the expression list)
This will make it invisible in the chart, but when you change to a table the column will still be there (indeed, it will remain if you copy the values or export the chart to excel also)
Erica
try something like this:
Hi Polisetti
In the expressions tab in the chart properties, highlight the expression that you wish to hide in the bar chart, and set it to "invisible" (check box to the right of the expression list)
This will make it invisible in the chart, but when you change to a table the column will still be there (indeed, it will remain if you copy the values or export the chart to excel also)
Erica
As you can see in my straight table i have two expression and my barchart only shows one.
What i did was just to uncheck the bar element under propeteries for barchart -> expression .display options.
Or you could check the invisible box as Erica Whalley mentions. Remember to be under properties for your chart
Create two separate charts... one straight table and second your combo or bar chart..
Create a button and set a variable something like vVar = 1.. now on action tab add an action so that when you click on button the vVar will change to 2
Straight Table
Layout Show Conditional vVar = 1 and
Chart show conditional vVar = 2
Hope this help.
Hi
Yes it is. In Properties | General, set up the fast type changes (bar chart and straight table) and then select the bar chart in Chart Types. Now you can set up all the properties for a bar chart view. Go back to Properties | General and select the straight table in Chart Types. Now set up the straight table options - and hide the column in Properties | Presentation.
HTH
Jonathan
Hoo Thank you very much............