| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
building chart from multiple sheets
I have 5 sheets and would like to build a stacked bar graph using data from
each. Say I have 4 values in A1, A2, A3 & A4 on each of these sheets. Each stacked bar is to respresent the 4 values from a single sheet. Is there any way to do this with out having to build a table on an extra page? Thanks, Brad K |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
building chart from multiple sheets
If I understand your data structure, you will need to use a range to
consolidate the data. http://peltiertech.com/Excel/ChartsH...iffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Brad K." wrote in message ... I have 5 sheets and would like to build a stacked bar graph using data from each. Say I have 4 values in A1, A2, A3 & A4 on each of these sheets. Each stacked bar is to respresent the 4 values from a single sheet. Is there any way to do this with out having to build a table on an extra page? Thanks, Brad K |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Chart Covering Info from Multiple Sheets | Charts and Charting in Excel | |||
| Need help building chart to track trends between two different sets of data | Charts and Charting in Excel | |||
| Chart sheets cause data sheets to be blank | Charts and Charting in Excel | |||
| chart data from same cell on multiple sheets | Charts and Charting in Excel | |||
Linear Mode
