PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Viewing 4 different graphs at once
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Viewing 4 different graphs at once
![]() |
Viewing 4 different graphs at once |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
HELP
I have a workbook with 4 sheets. Each sheet has a graph on it. I want to show all 4 graphs on one sheet in a window pane environment. But I can't click on the chart and get it to allow me to do a Window - Split Any help would be greatly appreciatied Thank Kell |
|
|
|
#2 |
|
Guest
Posts: n/a
|
Hi Kelly -
Insert a blank worksheet. Right click on each chart in turn, select Location from the pop up menu, select the As Object option, and select the new sheet from the drop down list. When you've gotten all four charts onto the sheet, you can arrange them to your liking. If you hold down the Alt key while moving and resizing, the edges of the charts will stick to the borders of the underlying cells. I can get my four charts to cover the ranges A1:K24, L1:V24, A25:K48, and L25:V48 on this monitor I'm using right now. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Kelly wrote: > HELP! > > I have a workbook with 4 sheets. Each sheet has a graph on it. I want to show all 4 graphs on one sheet in a window pane environment. But I can't click on the chart and get it to allow me to do a Window - Split. > > Any help would be greatly appreciatied! > > Thanks > Kelly > > |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

