|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 6th, 2004, 04:31 AM
|
|||
|
|||
How do I chart using different sheets (I could in 123)
I want to create a chart that uses the same cell in several sheets as the x
axis, i.e create an x axis through several sheets instead of a row or column in one sheet. Likewise the y axis will be a range through several sheets. I could do this easily in 123 but have not found out the way in Excel 
|
|
#2
September 6th, 2004, 12:50 PM
|
|||
|
|||
|
All the data in a series has to be on the same sheet. Jon Peltier has
instructions for summarizing data from different sheets: http://peltiertech.com/Excel/ChartsH...iffSheets.html WiltonRed wrote: I want to create a chart that uses the same cell in several sheets as the x axis, i.e create an x axis through several sheets instead of a row or column in one sheet. Likewise the y axis will be a range through several sheets. I could do this easily in 123 but have not found out the way in Excel -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
| Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
| Controls on chart sheets | Del Cotter | Charts and Charting | 6 | April 19th, 2004 10:28 AM |
| horizontal bar chart print settings messed up when all sheets selected | Mary | Charts and Charting | 0 | April 15th, 2004 07:46 PM |
| Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |
Linear Mode
