A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sizing plot areas equally?



 
 
Thread Tools Display Modes
  #1  
Old March 5th, 2004, 06:42 AM
wlotto
external usenet poster
 
Posts: n/a
Default 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  
Old March 5th, 2004, 04:22 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default 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  
Old March 6th, 2004, 07:11 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default 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  
Old March 7th, 2004, 05:08 PM
wlotto
external usenet poster
 
Posts: n/a
Default 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  
Old March 8th, 2004, 02:28 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default 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  
Old March 14th, 2004, 03:29 PM
Brian Reilly, MS MVP
external usenet poster
 
Posts: n/a
Default 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  
Old March 15th, 2004, 06:47 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:44 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.