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
|
|||
|
|||
Sizing plot areas equally?
How could I size chart's plot areas equally, height and
width? Both charts have different series and categories. - thanks. |
#2
|
|||
|
|||
Sizing plot areas equally?
The easiest non-programmatic solution:
Stack the two charts one on top of the other. For whichever is on top: double-click each of the Plot Area and the Chart Area. In the respective dialog box, from the Patterns tab, set the Area to None. Now, size the two charts to achieve the desired effect / alignment. Once done, position the charts as desired. For the chart that had the plot/chart area set to none, reset the two area to the original. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... How could I size chart's plot areas equally, height and width? Both charts have different series and categories. - thanks. |
#3
|
|||
|
|||
Sizing plot areas equally?
Just this morning I added an add-in to my web site that does this:
http://peltiertech.com/Excel/Charts/...l#AlignChtDims I haven't crashed it in some less-than-extensive testing. I'd appreciate your trying it and letting me know how it works for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ wlotto wrote: How could I size chart's plot areas equally, height and width? Both charts have different series and categories. - thanks. |
#4
|
|||
|
|||
Sizing plot areas equally?
Thanks everybody for help.
Jon, I downloaded your zipped file. Allow me to ask this less than a beginner question. What is an add-in? What does it do? I have never added anything to my original soft as I am so afraid if anything wrong happens to it. - thanks. -----Original Message----- Just this morning I added an add-in to my web site that does this: http://peltiertech.com/Excel/Charts/....html#AlignCht Dims I haven't crashed it in some less-than-extensive testing. I'd appreciate your trying it and letting me know how it works for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ wlotto wrote: How could I size chart's plot areas equally, height and width? Both charts have different series and categories. - thanks. . |
#5
|
|||
|
|||
Sizing plot areas equally?
An addin is an Excel workbook that is configured not to be visible, but
does useful things. The official way to use an addin is to install it via the Tools menu, but for a one time use, you can double click on it in Explorer just like any Excel workbook. Download the latest version, which has had a couple glitches removed. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ wlotto wrote: Thanks everybody for help. Jon, I downloaded your zipped file. Allow me to ask this less than a beginner question. What is an add-in? What does it do? I have never added anything to my original soft as I am so afraid if anything wrong happens to it. - thanks. -----Original Message----- Just this morning I added an add-in to my web site that does this: http://peltiertech.com/Excel/Charts/....html#AlignCht Dims I haven't crashed it in some less-than-extensive testing. I'd appreciate your trying it and letting me know how it works for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ wlotto wrote: How could I size chart's plot areas equally, height and width? Both charts have different series and categories. - thanks. . |
#6
|
|||
|
|||
Sizing plot areas equally?
Hi Jon,
Just wandered over here, haven't here in a while. Downloaded your sample addin and did a quick test. I'm getting inconsistent results. Mostly correct. Occasionally not, then correct again. two column 2d charts with data red 1 white 2 blue 3 red 300 white 400 blue 500 change plot area in 2nd chart to smaller change font in second chart to 18 point resize everything. Inside left axes are identical, good Inside plotarea widths are usually the same which is good. Sometimes not the same. But almost always the Inside plot area positions are different relative to the chart area which would be nice when using these are sequential pages in PPT. Brian Reilly, PowerPoint MVP |
#7
|
|||
|
|||
Sizing plot areas equally?
Brian -
You crazy PowerPoint guys with your fancy font formatting (not to mention alliteration!). Can't you get by with Arial Narrow 10 pt??? All joking aside, I appreciate your comments. What makes this so frustrating is Excel's stubbornness in allowing precision formatting of its charts. When you have it almost working, you then come across some variation that doesn't cooperate. Did you know you get different results if you do the height and width in reverse order? The way I eventually used *seemed* to be more reliable. You also get different results depending on whether the chart is selected, or whether the chart object is selected, or whether the chart is not selected at all. Most reliable results come when the chart itself (the chart area) is selected. Sometimes you need to run the program more than once; sometimes a subsequent trial works, occasionally not. I think most people would prefer a chart that was sized from the inside out: plot inside area, then plot area, chart area, and finally whatever chart object is required to fit it all in. But in Excel you need to specify the container size (the chart object) first and foremost, and each successive layer inside the onion has to conform to every prior level of constraints. Finally, the most important dimensions, those of the plot inside area, can't even be directly set, only through algebra and iteration. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Brian Reilly, MS MVP wrote: Hi Jon, Just wandered over here, haven't here in a while. Downloaded your sample addin and did a quick test. I'm getting inconsistent results. Mostly correct. Occasionally not, then correct again. two column 2d charts with data red 1 white 2 blue 3 red 300 white 400 blue 500 change plot area in 2nd chart to smaller change font in second chart to 18 point resize everything. Inside left axes are identical, good Inside plotarea widths are usually the same which is good. Sometimes not the same. But almost always the Inside plot area positions are different relative to the chart area which would be nice when using these are sequential pages in PPT. Brian Reilly, PowerPoint MVP |
Thread Tools | |
Display Modes | |
|
|