PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Viewing 4 different graphs at once

Reply

Viewing 4 different graphs at once

 
Thread Tools Rate Thread
Old 10-02-2004, 03:46 PM   #1
=?Utf-8?B?S2VsbHk=?=
Guest
 
Posts: n/a
Default Viewing 4 different graphs at once


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


  Reply With Quote
Old 10-02-2004, 07:04 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: Viewing 4 different graphs at once

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
>
>


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off