Using pivot table values in a separate chart

Cashbagg

New Member
Joined
Sep 26, 2018
Messages
3
I've googled this, and can't get a concrete answer....
I've created a pivot table showing several items by month. Each month is able to drill down to 2 or 3 sub levels. When fully expanded, the pivot table would occupy many rows.

I need to extract cell data from this expanded pivot table and plot them on a chart elsewhere in my excel sheet.

Problem is, as soon as the pivot table is collapsed, then of course the cells used in the separate chart no longer show the data.

I assume I could just leave the pivot table full expanded, and then the cells would remain visible. Is there another way?

I hope I was clear.
Thx in advance.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,114,520
Messages
5,548,532
Members
410,845
Latest member
OldSwimmer1650
Top