Viewing 4 different graphs at once

K

Kelly

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graph to display Range Label and Mean 0
Where Did My Graph Go, Please ? 0
How to create visual report that combines resource remaining workacross multiple summary tasks 0
Stacked graph 0
i need to create a pie graph 1
Seemingly random plot area drift? 2
Excel graphs change when pasted into Publisher - Metafiles change? 0
Graphing calender chart with combined relative amounts for each date 0

Top