Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I get several graphs on one Excel page?
I'm trying to get four graphs of equal size on one page of Excel. I want them
to display in the four quarters of the page. When I try to make the second graph match the first one, it comes out tiny with a big space around. Resizing them is then subject to hit-and-miss. Is there any way to get this to happen neatly and automatically? Thanks. |
#2
|
|||
|
|||
How can I get several graphs on one Excel page?
I assume you're placing the charts onto a worksheet. You can line the
charts up with the cell boundaries if you hole ALT while moving and resizing the charts. If you think ahead, you should make the first chart, and get it all formatted the way you like it. Then make a copy of the chart; I like to hold CTRL while dragging the chart to the new location. Finally, change the data source, using the Source Data command from the Chart menu, and the Series tab: change the range indicated in the boxes for each series. This way you are not changing the size of chart elements after setting them in the first chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Bethany wrote: I'm trying to get four graphs of equal size on one page of Excel. I want them to display in the four quarters of the page. When I try to make the second graph match the first one, it comes out tiny with a big space around. Resizing them is then subject to hit-and-miss. Is there any way to get this to happen neatly and automatically? Thanks. |
#3
|
|||
|
|||
How can I get several graphs on one Excel page?
Thanks Jon!
I have accomplished the key part of this, which is changing the data series. What a good idea! Cheers. However, I'm having trouble with the other, more basic aspects of your advice. Copying a graph within the page seems not to happen (the best I can get is a duplicate line on the same graph!), because the 'copy' function is not lit up when I click on the graph, although this part should be easy. And I've been putting the graphs in a clean chart page; if I try putting them into a ruled 'sheet' they come out all tiny with big wording. If you or anyone could just fill in the gaps for me, I would be so grateful! Many thanks, Bethany. "Jon Peltier" wrote: I assume you're placing the charts onto a worksheet. You can line the charts up with the cell boundaries if you hole ALT while moving and resizing the charts. If you think ahead, you should make the first chart, and get it all formatted the way you like it. Then make a copy of the chart; I like to hold CTRL while dragging the chart to the new location. Finally, change the data source, using the Source Data command from the Chart menu, and the Series tab: change the range indicated in the boxes for each series. This way you are not changing the size of chart elements after setting them in the first chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Bethany wrote: I'm trying to get four graphs of equal size on one page of Excel. I want them to display in the four quarters of the page. When I try to make the second graph match the first one, it comes out tiny with a big space around. Resizing them is then subject to hit-and-miss. Is there any way to get this to happen neatly and automatically? Thanks. |
#4
|
|||
|
|||
How can I get several graphs on one Excel page?
Right!! I think I've got it. The trick was to make the graphs full size
first, and to resize them later; making a small graph to start with merely leaves white opaque space around the edge. Likewise to copy I can then copy the whole page, not just the graph axes area which does'nt work. This has been great advice, thanks. "Jon Peltier" wrote: I assume you're placing the charts onto a worksheet. You can line the charts up with the cell boundaries if you hole ALT while moving and resizing the charts. If you think ahead, you should make the first chart, and get it all formatted the way you like it. Then make a copy of the chart; I like to hold CTRL while dragging the chart to the new location. Finally, change the data source, using the Source Data command from the Chart menu, and the Series tab: change the range indicated in the boxes for each series. This way you are not changing the size of chart elements after setting them in the first chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Bethany wrote: I'm trying to get four graphs of equal size on one page of Excel. I want them to display in the four quarters of the page. When I try to make the second graph match the first one, it comes out tiny with a big space around. Resizing them is then subject to hit-and-miss. Is there any way to get this to happen neatly and automatically? Thanks. |
#5
|
|||
|
|||
How can I get several graphs on one Excel page?
Yes, you have to do ALL the formatting in the first chart, otherwise it's impossible
to make all the changes the same way to each chart. Then you need to select the chart area before copying, as you've discovered, which is the rectangular area that contains all of the individual elements of the chart. I'll have to try to remember to describe these steps more clearly. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Bethany wrote: Right!! I think I've got it. The trick was to make the graphs full size first, and to resize them later; making a small graph to start with merely leaves white opaque space around the edge. Likewise to copy I can then copy the whole page, not just the graph axes area which does'nt work. This has been great advice, thanks. "Jon Peltier" wrote: I assume you're placing the charts onto a worksheet. You can line the charts up with the cell boundaries if you hole ALT while moving and resizing the charts. If you think ahead, you should make the first chart, and get it all formatted the way you like it. Then make a copy of the chart; I like to hold CTRL while dragging the chart to the new location. Finally, change the data source, using the Source Data command from the Chart menu, and the Series tab: change the range indicated in the boxes for each series. This way you are not changing the size of chart elements after setting them in the first chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Bethany wrote: I'm trying to get four graphs of equal size on one page of Excel. I want them to display in the four quarters of the page. When I try to make the second graph match the first one, it comes out tiny with a big space around. Resizing them is then subject to hit-and-miss. Is there any way to get this to happen neatly and automatically? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Varying page Excel report | Excel Discussion (Misc queries) | |||
Excel Page Range Printing Problems | Excel Discussion (Misc queries) | |||
How to place a border on every page in excel? | Excel Worksheet Functions | |||
Open excel from htm page | Excel Discussion (Misc queries) | |||
Microsoft Excel tries to load front page on opening | Excel Discussion (Misc queries) |