+ Reply to Thread
Results 1 to 3 of 3

HOW TO? area (background of a scatter plot (graph))

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    somewhere
    MS-Off Ver
    Excel 2013
    Posts
    2

    Question HOW TO? area (background of a scatter plot (graph))

    Hello everybody

    I have a scatter plot and I need to draw on the background some simple areas (rectangles).

    Here is an example helpexcel.jpg The chart below shows the coordinates of the edges of the areas that I want to draw.

    Can anyone halp me?

    Thank you in advance for you replay

  2. #2
    Registered User
    Join Date
    01-16-2014
    Location
    somewhere
    MS-Off Ver
    Excel 2013
    Posts
    2

    Red face Re: HOW TO? area (background of a scatter plot (graph))

    solved using this tutorial: http://peltiertech.com/WordPress/sha...scatter-chart/

    it's pretty long to do and understand... but you just need to concentrate

    I made a plot with 7 areas.. please see the file attached!

    help2.jpg

    good luck

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: HOW TO? area (background of a scatter plot (graph))

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've found and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Creating a scatter graph with Red / Amber / Green background coloured plotting area
    By Marcos Aristotelous in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-03-2013, 08:30 AM
  2. How do I add an area under a curve on a scatter plot ?
    By tja26 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-09-2012, 10:40 AM
  3. Plot points on a area chart or plot areas on a scatter chart
    By maggy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-17-2012, 04:39 AM
  4. color boxes are the plot area background
    By Barry Au in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-03-2007, 06:43 PM
  5. [SOLVED] How do u set the PLOT AREA to nearest mm in Excel Scatter Graph .
    By fh in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-03-2005, 09:05 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