+ Reply to Thread
Results 1 to 3 of 3

Excel chart: put a box around each point

  1. #1
    Registered User
    Join Date
    07-07-2016
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    28

    Excel chart: put a box around each point

    Hi,

    So I have some X,Y points that I want to plot on a chart. And I want to also 'plot' a square surrounding each point, with the X,Y point at the center of the square box. The size of the box will be the same for every point in the chart, let's say 15x15 units. The X,Y points will be 15 units apart, so the boxes will just touch each other (no overlapping).

    Any ideas,

    Thanks,
    Angus

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Excel chart: put a box around each point

    Is this the effect you want?
    (data values for "y" are in red - squares are centred on that point)

    ChartDataMarkerChart.jpg




    to get that effect:

    ChartDataMarker.jpg


    or with data label in middle of the square:

    ChartDataMarkerChart2.jpg
    Last edited by kev_; 07-05-2017 at 06:02 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    07-07-2016
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    28

    Re: Excel chart: put a box around each point

    Hi Kev,

    Sort of, I think this could be workable.
    The squares in the image should be touching (where they are close) and they pretty much do for the most part. So it looks good enough.

    Thanks,

    bin.png

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Checking in Excel Chart to Share point using VBA
    By cpdenardis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2016, 08:29 PM
  2. Power Point VBA Excel Chart Refresh
    By Jietoh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2016, 05:36 PM
  3. Resize copied Chart from Excel to Power Point
    By LPrenici in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2014, 08:54 AM
  4. Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  5. Power Point Chart linked to Excel Chart
    By pr4t3ek in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-24-2009, 11:33 AM
  6. Replies: 1
    Last Post: 07-30-2009, 10:12 AM
  7. How do I get a value of a calculated point on an excel line chart?
    By klc6778 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-25-2005, 10:05 PM

Tags for this Thread

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