Results 1 to 7 of 7

Finding starting point of chart plot area

Threaded View

  1. #1
    Registered User
    Join Date
    05-29-2007
    Posts
    4

    Finding starting point of chart plot area

    I want to add some vertical lines to an Excel chart, so I started off by finding the dimensions of the chart and plot area, using the following:
        ActiveChart.ChartArea.Select
        L = ActiveSheet.Shapes(MyChart).Left
        T = ActiveSheet.Shapes(MyChart).Top
        W = ActiveSheet.Shapes(MyChart).Width
        H = ActiveSheet.Shapes(MyChart).Height
        ActiveChart.PlotArea.Select
        PL = ActiveChart.PlotArea.Left
        PT = ActiveChart.PlotArea.Top
        PW = ActiveChart.PlotArea.Width
        PH = ActiveChart.PlotArea.Height
    My problem is with the PlotArea.Left -- If I relocate the plot area to the far left, I get a value of 0, which is the left edge of the Y-axis scale. The actual plot area is further to the right.

    How do I find the left edge of the actual plot area?
    Last edited by Leith Ross; 09-16-2008 at 07:41 PM. Reason: Added code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Forcing a chart to plot only relevant data entries
    By Sam Gregoir in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-07-2008, 07:02 AM
  2. Change Plot Area in Relation to Whole Chart
    By driffert in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-11-2008, 01:53 AM
  3. Pie Chart Plot Area
    By beets in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-07-2008, 04:44 PM
  4. Identifying a particular section in the plot area
    By HAYLEYFARMINER in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-12-2008, 05:05 PM
  5. Going insane!
    By kik in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 01-31-2007, 08:21 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1