Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Conditional Data Point Colors For Scatter Plot Chart

  1. #1
    Join Date
    5th May 2008
    Posts
    4

    Conditional Data Point Colors For Scatter Plot Chart

    Hi

    I have to create a chart XY Scatter plot in excel. I have to differentiate the data points color based on the another column "category". Now I can change the data points color manually. Since the number of points is huge, is it possible to color the data points based on a column?

    Thanks,
    Iswaria

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,717

  3. #3
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Conditional Data Point Colors For Scatter Plot Chart

    If you only need different colours simply use multiple series and formula to determine which series the data should appear in.

    If you need more help post an example of your workbook and explain the rules for determining which points have which formatting

    Cheers
    Andy


  4. #4
    Join Date
    5th May 2008
    Posts
    4

    Re: Conditional Data Point Colors For Scatter Plot Chart

    Quote Originally Posted by Andy Pope
    If you only need different colours simply use multiple series and formula to determine which series the data should appear in.

    If you need more help post an example of your workbook and explain the rules for determining which points have which formatting
    I have three columns. The first columns are data column and third column is category column, which should be used for coloring. For example, the first row and fourth row have the value "1". So, I want color of the data points of first row and fourth should be same. Similary for each category.

    Example:

    x-value y-value Category
    12 2 1
    24 4 2
    36 6 3
    48 2 1

    Thanks.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    12th October 2006
    Location
    London
    Posts
    160

    Re: Conditional Data Point Colors For Scatter Plot Chart

    Hi,

    See the attached file. Create three new data series using IF formulas, one for each of your categories, plot them all against the x-axis data, and format each series appropriately.

    Is this anything like what you wanted?

    Dave
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    5th May 2008
    Posts
    4

    Re: Conditional Data Point Colors For Scatter Plot Chart

    Quote Originally Posted by davecurtis
    Hi,

    See the attached file. Create three new data series using IF formulas, one for each of your categories, plot them all against the x-axis data, and format each series appropriately.

    Is this anything like what you wanted?

    Dave

    Hi Dave,

    This is exactly what I wanted. Thanks a lot for your help.

    Iswaria

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    28th July 2010
    Posts
    1

    Re: Conditional Data Point Colors For Scatter Plot Chart

    Hi,

    I am new to the forum. I have been trying with varying success to do something like this. However, my data varies a lot on both the x and the y axes.

    Here is an example.

    xYcolor-0.7548.18681141.7429922.134.000493-1.554.330624-0.2533.4997653.587533.66741-0.425.554652-0.17530.0501333.862555.241394-2.1533.101775

    While I could probably categorize a bit, these data are actual values related to test scores and part of the reason I want to use such a plot is that I want to be able, visually, to determine which schools need help.

    Thanks for any tips!

    SORRY, LOOKED FURTHER AT EXAMPLE AND HAVE NOW RESOLVED ISSUE. THANKS!

    Quote Originally Posted by iswariak View Post
    Hi Dave,

    This is exactly what I wanted. Thanks a lot for your help.

    Iswaria
    Last edited by excbop; July 28th, 2010 at 03:02. Reason: figured out problem

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Label data point in Scatter chart
    By tqv1969 in forum EXCEL HELP
    Replies: 6
    Last Post: October 28th, 2010, 18:03
  2. Label Chart Scatter Plot Markers
    By tuesday in forum EXCEL HELP
    Replies: 2
    Last Post: June 4th, 2008, 22:37
  3. Replies: 10
    Last Post: May 17th, 2008, 19:06
  4. Formatting X Axis On Scatter Plot Chart
    By wednesday in forum EXCEL HELP
    Replies: 3
    Last Post: July 28th, 2007, 04:00
  5. Replies: 4
    Last Post: August 11th, 2005, 15:55

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
  •  
porno