populate chart from bar chart

[#1]

Is there a way that I can create a chart table that has the detail for everything that makes up a bar in a bar chart?

I am trying to get the detail for all revenue if I click on the revenue bar for customer A(see attached image) into a detail table that somone can view and/or export.  Essentially, I want to be able to drill down into detail for the chart.  It can populate another chart on the same or different sheet.  Thanks for any help.

[IAMDV]

Hi,

I think you can use the GetFieldSelection() Function for Revenue Field to capture the selections. Once user clicks on the main chart (attached above) on the Revenue Bars, you can hide this chart by conditional Show/Hide in the Chart Properties. Then you can show the second chart which shows detailed information. I would recommend locking the position of the charts after overlying them, you can change the properties in layout menu and uncheck the allow move/size.

I hope this helps!

Cheers - DV

[#3]

Could you tell me where this function  should be inserted?  I dont see a spot in any of the property pages that you can put functions other than the definition of the expressions themselves.  Example code may help.  Thanks

[#4]

I attached an example with dynamic visiblity based on cutomer selection. You can see the property in the layout tab of the chart properties.

Regards,

Kiran.

[#5]

I am sure this would answer my question, but I am unable to read the file.  I am using the  personal edition that is free and it will not allow me to read a file unless it is created by me.  Is there a way to get around this to look at examples like this?  Thanks for your help.

[IAMDV]

Yes, Kiran demonstrated the solution I have explained earlier. Thanks Kiran!

You will generally have 3/4 attempts to open others files in personal edition. If you wanted to see the functionality then you can use one of the attempt. I hope this helps!

Cheers - DV