If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Resizing Pivot Charts and pasting into Word documents
Hello
I would like to paste 3 Pivot charts (created in Excel) into Word. These charts have to be displayed side-by- side, i.e., in a row. However, when I paste the charts, they appear to be bigger than I wanted them to appear - the only way I can (currently) display them in a word document is in a column (one under the other). May I please ask for your kind help - is it possible to resize these charts before after pasting, and have control over how they appear in a Word document? Thank you |
#2
|
|||
|
|||
Resizing Pivot Charts and pasting into Word documents
Hi Stan -
Embed the charts in a worksheet: right click the chart, select Location from the pop up menu, and select a sheet from the drop down list next to "As Object In". Put the three charts side by side and resize them as much as you need. If you hold down the Alt key while moving and resizing the charts, their edges will align with cell boundaries. I have some hints on copying and pasting charts from Excel into other applications on my web site; it's mostly PowerPoint, but the hints work well with Word as well. http://www.geocities.com/jonpeltier/Excel/XL_PPT.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Stan wrote: Hello I would like to paste 3 Pivot charts (created in Excel) into Word. These charts have to be displayed side-by- side, i.e., in a row. However, when I paste the charts, they appear to be bigger than I wanted them to appear - the only way I can (currently) display them in a word document is in a column (one under the other). May I please ask for your kind help - is it possible to resize these charts before after pasting, and have control over how they appear in a Word document? Thank you |
#3
|
|||
|
|||
Resizing Pivot Charts and pasting into Word documents
Embed the charts in a worksheet: right click the chart,
select Location from the pop up menu, and select a sheet from the drop down list next to "As Object In". Put the three charts side by side and resize them as much as you need. If you hold down the Alt key while moving and resizing the charts, their edges will align with cell boundaries. Thank you very much for your reply. I try embedding the Pivot chart in a worksheet, and then resizing, copying and pasting it into Word. It works (thanks!!), but there are several problems: - the area taken up by the actual surface I am plotting is now about 1/8th of the area of the chart. The rest is taken up with field names, the legend, chart title, and blank space. Is it possible to avoid this unfortunate effect? - on top of the chart, there are words "Drop page fields here" this text does not disappear when I paste the chart into Word. Is it possible to get rid of this - it looks very unprofessional... - Is it possible to control the location of the legend and the pivot table field titles (with the downward pointing arrow beside them)? One of them is even overlapping the other text on the chart... Thank you! |
#4
|
|||
|
|||
Resizing Pivot Charts and pasting into Word documents
Stan -
You've hit on three of the reasons I don't care much for pivot charts. It's a really slick idea that hasn't really been implemented the way I'd have liked. So what's a poor boy to do? Make regular charts, over which you have much greater control. Select a cell which isn't part of a pivot table, and start the chart wizard. In step 1, choose a chart type. In step 2, click on the series tab, then press the Add button. Select the worksheet ranges containing the series Name, Y Values, and X Values (or Category Labels). Press Add again for additional series. Finish the wizard the regular way, choosing 'As Object In' and the appropriate worksheet for Location in step 4. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Stan wrote: Embed the charts in a worksheet: right click the chart, select Location from the pop up menu, and select a sheet from the drop down list next to "As Object In". Put the three charts side by side and resize them as much as you need. If you hold down the Alt key while moving and resizing the charts, their edges will align with cell boundaries. Thank you very much for your reply. I try embedding the Pivot chart in a worksheet, and then resizing, copying and pasting it into Word. It works (thanks!!), but there are several problems: - the area taken up by the actual surface I am plotting is now about 1/8th of the area of the chart. The rest is taken up with field names, the legend, chart title, and blank space. Is it possible to avoid this unfortunate effect? - on top of the chart, there are words "Drop page fields here" this text does not disappear when I paste the chart into Word. Is it possible to get rid of this - it looks very unprofessional... - Is it possible to control the location of the legend and the pivot table field titles (with the downward pointing arrow beside them)? One of them is even overlapping the other text on the chart... Thank you! |
#5
|
|||
|
|||
Resizing Pivot Charts and pasting into Word documents
Hello John
Thanks for your reply! I am sorry, I had still encountered problems - may I ask another question, please? So what's a poor boy to do? Make regular charts, over which you have much greater control. Suppose I have the following: x y z 1 2 3 2 3 4 5 6 7 I would like to plot a Surface - here, z describes the height for a particular point (x,y). Select a cell which isn't part of a pivot table, and start the chart wizard. I create a pivot table with the data above. In cells B44, I have numbers 1, 2, 5. In cells A5:A7, I have numbers 2, 3, 6. In step 1, choose a chart type. In step 2, click on the series tab, then press the Add button. Select the worksheet ranges containing the series Name, Y Values, and X Values (or Category Labels). No matter what combinations I try, I get nonsense... what should I enter at this stage, for this example? I appreciate your kind help, John Stan |
#6
|
|||
|
|||
Resizing Pivot Charts and pasting into Word documents
Stan -
Yeah, surface charts aren't the most powerful in Excel's arsenal. You need one factor in rows and the other in columns, then you need a Z value for each cell in the grid, like this: a b c d A 1 2 3 3 B 2 2 3 4 C 2 3 4 4 D 3 4 4 5 If your list of x-y-z values has all the M x N data you need, great. Otherwise, you have blanks in the pivot table, which plot as spikes down to the floor of the chart. I just checked, and Tools Options Chart Plot Blanks As ... Interpolate doesn't seem to help. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Stan wrote: Hello John Thanks for your reply! I am sorry, I had still encountered problems - may I ask another question, please? So what's a poor boy to do? Make regular charts, over which you have much greater control. Suppose I have the following: x y z 1 2 3 2 3 4 5 6 7 I would like to plot a Surface - here, z describes the height for a particular point (x,y). Select a cell which isn't part of a pivot table, and start the chart wizard. I create a pivot table with the data above. In cells B44, I have numbers 1, 2, 5. In cells A5:A7, I have numbers 2, 3, 6. In step 1, choose a chart type. In step 2, click on the series tab, then press the Add button. Select the worksheet ranges containing the series Name, Y Values, and X Values (or Category Labels). No matter what combinations I try, I get nonsense... what should I enter at this stage, for this example? I appreciate your kind help, John Stan |
#7
|
|||
|
|||
Resizing Pivot Charts and pasting into Word documents
Thank you!!
I didn't know how "Surface plots" work, and now I do! Yeah, surface charts aren't the most powerful in Excel's arsenal. You need one factor in rows and the other in columns, then you need a Z value for each cell in the grid, like this: a b c d A 1 2 3 3 B 2 2 3 4 C 2 3 4 4 D 3 4 4 5 If your list of x-y-z values has all the M x N data you need, great. Otherwise, you have blanks in the pivot table, which plot as spikes down to the floor of the chart. I just checked, and Tools Options Chart Plot Blanks As ... Interpolate doesn't seem to help. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Stan wrote: Hello John Thanks for your reply! I am sorry, I had still encountered problems - may I ask another question, please? So what's a poor boy to do? Make regular charts, over which you have much greater control. Suppose I have the following: x y z 1 2 3 2 3 4 5 6 7 I would like to plot a Surface - here, z describes the height for a particular point (x,y). Select a cell which isn't part of a pivot table, and start the chart wizard. I create a pivot table with the data above. In cells B44, I have numbers 1, 2, 5. In cells A5:A7, I have numbers 2, 3, 6. In step 1, choose a chart type. In step 2, click on the series tab, then press the Add button. Select the worksheet ranges containing the series Name, Y Values, and X Values (or Category Labels). No matter what combinations I try, I get nonsense... what should I enter at this stage, for this example? I appreciate your kind help, John Stan . |
Thread Tools | |
Display Modes | |
|
|