Pivot table in Labview

[prabhu_er]

I want to create the table with graph which should be act as a Pivot table.

If anybody used these in Labview,pls help me...

[Gregory]

Can you be more specific about what your data looks like and what you want to graph?

[prabhu_er]

Hi,

Here I attached the Excel file contains data's in sheet 1 which are my inputs.

Same as plotted in chart and table in sheet 2 using Pivot.

In Ecel, When i changing the rows, colums,filters and values in pivot table , chart and table will update accordingly. This i needs to implement in Labview.

I tried to insert ActiveX object of MS Pivot Table in Labview. But I m not able to insert data's in it...

[ben64]

---

@prabhu_er wrote:

Hi,

Here I attached the Excel file contains data's in sheet 1 which are my inputs.

Same as plotted in chart and table in sheet 2 using Pivot.

In Ecel, When i changing the rows, colums,filters and values in pivot table , chart and table will update accordingly. This i needs to implement in Labview.

I tried to insert ActiveX object of MS Pivot Table in Labview. But I m not able to insert data's in it...

---

Please show what you tried in LabVIEW (post your vi), it might help us better understand your problem.

Ben64

[prabhu_er]

Hi,

In the attached vi , I inserted the ActiveX Object of Microsoft Office Pivot Table.

I do not know how to use this pivot table. 

If there is any other ways to plot pivot table and chart,Please let me know