Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post
    I have a charting utility that plots data with VBA. It worked fine with XL97 - XL2000. It almost works with XL2003, but the chart sizing is driving me crazy. On a Chart Sheet, I want to set the ChartArea height & width and the PlotArea height & width. I seem to be able to set the PlotArea size, but the ChartArea keeps autosizing to the width of the sheet. Any ideas on how to stop the autosizing? TIA --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Tell us more about the utility - what is it called, where did it come from, is the code accessible?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post
    Code is too complicated, I may make a simple version that shows the problem.

    But, you can see the problem outside of code:

    Create a simple scatter chart --
    In A1:B2, put some data, say 1, 2, 3, 4
    Select A1:B2 & press the chart wizard.
    Choose XY (Scatter) & take all of the defaults except step 4: tick "As a new sheet"

    Fix the other new features of 2003:
    Click in the Chart Area & use the arrow keys to navigate to plot area
    Resize the plot area to use the upper-left 1/4 of the Chart Area
    Click on the Series 1 label & delete it

    Now, you should be able to resize the Chart Area, but you cannot. If the height is max, you can change the width. And if the width is max, you can change the height. But, you cannot change both!

    BTW, documentation for 2003 says Height & Width are read only, unlike every other version! Agggggggggggg!

    Currently trying to use an embedded chart instead of a chart sheet.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    This is NOT a solution, but interestingly (or not)


    If you create the chart in 2003, chart area appears to be non sizeable ON the Chart sheet, and also using VBA.
    Then save it as .xls


    Now open it up in 2007.
    It can be now be sized, so looks like they added it into 2007.


    So, now save it (standard .xls) in 2007.


    Now open it in 2003 and voila, the chart area of the chart sheet is sizeable in 2003.


    Have not figured out how to, or even if it is possible to change the read only nature
    of the height and width property of the chart area in 2003 though,
    but implications are that it ought to be possible.



    [attachment=88266:XY.jpg]



    This is snapped from the Excel 2003 at the end of the above process.


    I know it doesn't really help but .....





    Attached Images Attached Images
    Andrew

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •