I need to build a chart with following sructure .
How to add History ,Actual, R/H% to the chart ?
If you have the Field for that values, you can just drag and drop to the top of the Pivot table.
If you don't have, you need to look on ValueList and Pick(Match()) function..
I dont want have History ,Actual, R/H% fields , i want to customize the chart by adding as Headers.
I didn't get you. Can you give an example or sample?
Do you want to show / hide the Fields? If so, you can create 3 text boxes and put it in your top of the chart..
Retrieving data ...