Home |
Search |
Today's Posts |
#1
|
|||
|
|||
2 graphs on 1 single chart cheet
Hi all,
I searched the archives, but am searching no good I think. Is it possible to enter 2 independent graphs on 1 chart sheet? I'm not referring to overlay charts. I thought to remember I read about it, but can't find it back. I like to have 2 graphs on top of one another in the same chart sheet. Is there a manner to accomplish this or is this just wishfull thinking? I know I can embed them in a standard worksheet, but the file is existing already. Many thanks in advance. If not possible, that's an as valid reply as well. TIA Eric |
#2
|
|||
|
|||
Eric,
Yes - you can include multiple charts on a single chart sheet. When you go through the Chart Wizard, you can use the Chart Location command to move embedded charts to a chart sheet. Also, the second drop-down option in the Chart Location step of the Chart Wizard includes an option to load the new chart into a chart sheet. To tile the charts correctly within the chart sheet, you might need to create the chart sheet and then delete the original chart from within that sheet. Then, load the charts that you need into the chart sheet via the Chart Wizard. ---- Regards, John Mansfield http://www.pdbook.com "Eric Desart" wrote: Hi all, I searched the archives, but am searching no good I think. Is it possible to enter 2 independent graphs on 1 chart sheet? I'm not referring to overlay charts. I thought to remember I read about it, but can't find it back. I like to have 2 graphs on top of one another in the same chart sheet. Is there a manner to accomplish this or is this just wishfull thinking? I know I can embed them in a standard worksheet, but the file is existing already. Many thanks in advance. If not possible, that's an as valid reply as well. TIA Eric |
#3
|
|||
|
|||
John,
Many thanks, I try tomorrow, hope it works (better that I can get it to work :):)). Kind regards Eric "John Mansfield" wrote in message ... Eric, Yes - you can include multiple charts on a single chart sheet. When you go through the Chart Wizard, you can use the Chart Location command to move embedded charts to a chart sheet. Also, the second drop-down option in the Chart Location step of the Chart Wizard includes an option to load the new chart into a chart sheet. To tile the charts correctly within the chart sheet, you might need to create the chart sheet and then delete the original chart from within that sheet. Then, load the charts that you need into the chart sheet via the Chart Wizard. ---- Regards, John Mansfield http://www.pdbook.com "Eric Desart" wrote: Hi all, I searched the archives, but am searching no good I think. Is it possible to enter 2 independent graphs on 1 chart sheet? I'm not referring to overlay charts. I thought to remember I read about it, but can't find it back. I like to have 2 graphs on top of one another in the same chart sheet. Is there a manner to accomplish this or is this just wishfull thinking? I know I can embed them in a standard worksheet, but the file is existing already. Many thanks in advance. If not possible, that's an as valid reply as well. TIA Eric |
#4
|
|||
|
|||
Eric -
John Walkenbach has a detailed example he http://www.pcworld.com/howto/article/0,aid,16305,00.asp - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Eric Desart wrote: Hi all, I searched the archives, but am searching no good I think. Is it possible to enter 2 independent graphs on 1 chart sheet? I'm not referring to overlay charts. I thought to remember I read about it, but can't find it back. I like to have 2 graphs on top of one another in the same chart sheet. Is there a manner to accomplish this or is this just wishfull thinking? I know I can embed them in a standard worksheet, but the file is existing already. Many thanks in advance. If not possible, that's an as valid reply as well. TIA Eric |
#5
|
|||
|
|||
:) Many thanks John, Jon, and link to John
I got it working, nice graph as a result (works as animation for soundwaves, still improving) This indeed gives me an additional option for future things to. A grateful Dutch guy. Eric. PS: has anybody always trouble with a flikkering screen when animating graphs? The whole screen is always redrawn. I always had that with Excel. Is there a way around that? Can it depend also on the graphical chart? Eric "Jon Peltier" wrote in message ... Eric - John Walkenbach has a detailed example he http://www.pcworld.com/howto/article/0,aid,16305,00.asp - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Eric Desart wrote: Hi all, I searched the archives, but am searching no good I think. Is it possible to enter 2 independent graphs on 1 chart sheet? I'm not referring to overlay charts. I thought to remember I read about it, but can't find it back. I like to have 2 graphs on top of one another in the same chart sheet. Is there a manner to accomplish this or is this just wishfull thinking? I know I can embed them in a standard worksheet, but the file is existing already. Many thanks in advance. If not possible, that's an as valid reply as well. TIA Eric |
#6
|
|||
|
|||
Eric -
After my post, I saw that John had the example right on his web site. Many years ago, I built my first animated chart, and it flickered like the devil. I avoided them for a long time, then within the past year I started making a few. No flickers, at least not as bad as I remember. I guess Windows and Excel (and the underlying hardware) have improved since my earlier attempts. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Eric Desart wrote: :) Many thanks John, Jon, and link to John I got it working, nice graph as a result (works as animation for soundwaves, still improving) This indeed gives me an additional option for future things to. A grateful Dutch guy. Eric. PS: has anybody always trouble with a flikkering screen when animating graphs? The whole screen is always redrawn. I always had that with Excel. Is there a way around that? Can it depend also on the graphical chart? Eric "Jon Peltier" wrote in message ... Eric - John Walkenbach has a detailed example he http://www.pcworld.com/howto/article/0,aid,16305,00.asp - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Eric Desart wrote: Hi all, I searched the archives, but am searching no good I think. Is it possible to enter 2 independent graphs on 1 chart sheet? I'm not referring to overlay charts. I thought to remember I read about it, but can't find it back. I like to have 2 graphs on top of one another in the same chart sheet. Is there a manner to accomplish this or is this just wishfull thinking? I know I can embed them in a standard worksheet, but the file is existing already. Many thanks in advance. If not possible, that's an as valid reply as well. TIA Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
Impedding/Overlaying Charts | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |