Excel Multi Tab Workbook and Charts

I have a multi tabbed workbook and want to chart data from one tab on another tab.

Example:
Tab = Civilian (summary view of this area)
 
Tab = all deals (raw data with lots of columns)
 
So ultimately I would like to create a pie chart on tab Civilian that shows all deals from "all deals" where column a=civilian and then chart changes in column G "forecast category" by sum of column J "TCV"
Matt PinkstonAsked:
Who is Participating?
 
BlueYonderCommented:
To reference another cell in another sheet user 'sheet name'!A1.

Reference multiple cells using 'sheet name'!A1:A20
0
 
englanddgCommented:
Yep.  Or just use the wizard and click on the reference cells/row/column.  It will use the format @BlueYonder mentioned.
0
 
Matt PinkstonAuthor Commented:
looking more for how to build the chart
0
 
Matt PinkstonAuthor Commented:
Excellent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.