• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • Last Modified:

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"
0
Matt Pinkston
Asked:
Matt Pinkston
  • 2
  • 2
1 Solution
 
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
 
englanddgCommented:
0
 
Matt PinkstonAuthor Commented:
Excellent
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now