LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Janwillem van Dijk
 
Posts: n/a
Default Resize chart area without resizing plot area

Hi,
With the help of your answers on my question of July 30 and some digging
in excel4 I succeeded in making the inside of the plot area exactly a
square with predefined dimensions.

I made a function that finds the dimensions of a rectangle that encloses
all elements in the plot including title, axes-titles and text boxes.

Now I want the chart area to fit tightly around all the actual plot
elements. But I do not succeed in resizing the chart area without
resizing the plot.

Is there some (hidden) feature that switches off autoresizing like there
is one for the font?

When I have a solution I will publish the final results of my endeavours
on this newsgroup of course.

Tanks,
Janwillem

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I alter plot area colour in a chart without a mouse? debbiecatal Charts and Charting in Excel 2 May 30th 05 04:11 AM
pie-charting non-numeric data Gina O'Brien Charts and Charting in Excel 4 May 20th 05 12:23 PM
How do I change the excel chart default plot area color? gg96555 Charts and Charting in Excel 2 February 8th 05 07:36 PM
Setting custom chart causes plot area to collapse Chiara Charts and Charting in Excel 0 January 20th 05 05:32 PM
Bar Chart Label Sizes [email protected] Charts and Charting in Excel 2 December 27th 04 03:19 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"