Quickest way to add large number of series to a chart

[Chets]

I have a pivot table with 70+ columns, each with named range. I'd like to add each of the column as a series to a chart. What's the quickest way (instead of manually adding one at a time)?

 

[Chihiro]

If it's pivot table, you can just go to PIVOTTABLE TOOLS ribbon and go to Analyze tab->PivotChart.

It will automatically select all data in the table. You can swap row/column as needed.

 

[Hui]

Write a simple macro

 

[Chets]

If it's pivot table, you can just go to PIVOTTABLE TOOLS ribbon and go to Analyze tab->PivotChart.

It will automatically select all data in the table. You can swap row/column as needed.

I have tried this approach and though it does work, it then prevents any manual addition of series. I'd like to be able to add series manual as well due to some data being overlaid from other datasheets.

 

[Hui]

Select the whole area
Insert Chart