This is a split board - You can return to the Split List for other boards.

Excel formatting question

#1Louisville15Posted 8/6/2013 5:22:04 AM
Ok, so I have a bunch of data points on sheet 1. I want sheet 2 to contain pie charts based on the data from sheet 1, which I know how to do. However, how do I make the charts on sheet 2 the exact same size, and aligned perfectly? Ideally I want to have a three column grid. Manually setting the chart dimensions gives the same size, but it's impossible to align them evenly. Halp!
---
i7 930 @ 3.6 | EVGA GTX 680 SC Signature 2 | EVGA E758 | 6GB G.Skill Ripjaws | Windows 8 | OCZ ZX1250 | 1TB WD Caviar Black | 240GB Mushkin Chronos | AW2310
#2ShubPosted 8/6/2013 5:26:50 AM
Select all your charts, go to the Drawing Tools (Format) tab, use the Align feature.
---
-What is best in life?
-To crush your enemies, see them driven before you, and to hear the lamentation of the women.
#3Louisville15(Topic Creator)Posted 8/6/2013 5:37:25 AM
Shub posted...
Select all your charts, go to the Drawing Tools (Format) tab, use the Align feature.


I tried that but it doesn't seem to work. For instance, align top moves all three to the top, but they all overlap.
---
i7 930 @ 3.6 | EVGA GTX 680 SC Signature 2 | EVGA E758 | 6GB G.Skill Ripjaws | Windows 8 | OCZ ZX1250 | 1TB WD Caviar Black | 240GB Mushkin Chronos | AW2310
#4ShubPosted 8/6/2013 5:42:40 AM
That should only happen if they overlapped to begin with.
---
-What is best in life?
-To crush your enemies, see them driven before you, and to hear the lamentation of the women.
#5Louisville15(Topic Creator)Posted 8/6/2013 5:51:39 AM
Shub posted...
That should only happen if they overlapped to begin with.


Ah, ok, got it! One more thing, how do I do that AND have the space between them be even? Like if I want CHART (.25" gap) CHART (.25" gap) CHART? Also, for the second row of charts, I'd like to have a .25" gap between their tops and row 1's bottoms.
---
i7 930 @ 3.6 | EVGA GTX 680 SC Signature 2 | EVGA E758 | 6GB G.Skill Ripjaws | Windows 8 | OCZ ZX1250 | 1TB WD Caviar Black | 240GB Mushkin Chronos | AW2310
#6ShubPosted 8/6/2013 6:05:24 AM
I didn't research this, but off the top of my head, I don't think you can tell Excel to space two objects by exactly a certain distance, however you can create a text box, manually set its width to 0.25", stick it against one side of a chart, stick your next chart against the text box, repeat as necessary, align everything, then remove the text boxes.
---
-What is best in life?
-To crush your enemies, see them driven before you, and to hear the lamentation of the women.
#7Louisville15(Topic Creator)Posted 8/6/2013 6:13:18 AM
Shub posted...
I didn't research this, but off the top of my head, I don't think you can tell Excel to space two objects by exactly a certain distance, however you can create a text box, manually set its width to 0.25", stick it against one side of a chart, stick your next chart against the text box, repeat as necessary, align everything, then remove the text boxes.


What if I just wanted all of the borders to touch? Is there an easy way to do this?
---
i7 930 @ 3.6 | EVGA GTX 680 SC Signature 2 | EVGA E758 | 6GB G.Skill Ripjaws | Windows 8 | OCZ ZX1250 | 1TB WD Caviar Black | 240GB Mushkin Chronos | AW2310
#8ShubPosted 8/6/2013 6:16:05 AM
I think you'll have an easier time doing page layout stuff in Word or PowerPoint, Excel is not made for this. But it's easy to make the borders touch, just drag and drop the charts with your mouse, then use the align feature.
---
-What is best in life?
-To crush your enemies, see them driven before you, and to hear the lamentation of the women.
#9Louisville15(Topic Creator)Posted 8/6/2013 6:27:44 AM
Gotcha. Yeah, I know it'd be much easier but I want it all contained in one file :(

Thanks for the help!
---
i7 930 @ 3.6 | EVGA GTX 680 SC Signature 2 | EVGA E758 | 6GB G.Skill Ripjaws | Windows 8 | OCZ ZX1250 | 1TB WD Caviar Black | 240GB Mushkin Chronos | AW2310
#10ShubPosted 8/6/2013 6:44:55 AM
If you want everything in one file, then you can embed your Excel stuff into Word. MS Office is very good at integrating its various components seamlessly between one another.
---
-What is best in life?
-To crush your enemies, see them driven before you, and to hear the lamentation of the women.