Solved

Excel Multi Tab Workbook and Charts

Posted on 2014-03-25
5
332 Views
Last Modified: 2014-04-11
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
Comment
Question by:Matt Pinkston
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by:BlueYonder
ID: 39953104
To reference another cell in another sheet user 'sheet name'!A1.

Reference multiple cells using 'sheet name'!A1:A20
0
 
LVL 3

Expert Comment

by:englanddg
ID: 39953112
Yep.  Or just use the wizard and click on the reference cells/row/column.  It will use the format @BlueYonder mentioned.
0
 

Author Comment

by:Matt Pinkston
ID: 39953136
looking more for how to build the chart
0
 
LVL 3

Accepted Solution

by:
englanddg earned 500 total points
ID: 39953143
0
 

Author Closing Comment

by:Matt Pinkston
ID: 39995458
Excellent
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question