How to draw a chart for a part of pivot table

[KiKi]

I have 5 columns in pivot table however i want to draw a line graph including only 4 fields. Can i draw a graph using part of pivot table.?

 

[p45cal]

You can but..
Insert a chart in the normal way but before you do so, make sure the selected cell is not near any data. Then right-click the chart, select Select Data and choose the series you want to add. The data source range will not, however, change with the changing pivot table.

 

[KiKi]

it gives the error as " The reference is not valid. References for titles, values, sizes, or data labels must be a single cell, row or column" when i choose select data and choose the range from pivot table which i want to map

 

[p45cal]

"References for titles, values, sizes, or data labels must be a single cell, row or column"

the clue is in the above.. one series at a time.

 

[KiKi]

the clue is in the above.. one series at a time.

It was solved ..thanks though