+ Reply to Thread
Results 1 to 3 of 3

Scatter Chart

  1. #1
    Registered User
    Join Date
    12-15-2015
    Location
    Austin, USA
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Scatter Chart

    I want to create an excel scatter chart that only show one indicator but this indicator is located on an XY axis based on several inputs:

    Therefore, the X-axes position is dependent on 5 criteria's, each criteria value will have an effect as to where the indicator are positioned. Same accounts for the "Y" value.

    Attach is my spreadsheet, and the selections are the cells that have values. Basically, we want to use this as a sales tool when we assess a new sales opportunity. The Values of column "C" would be X-values, and "F" would be the Y-values.Book1.xlsx

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Scatter Chart

    Pretty straightforward.
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    12-15-2015
    Location
    Austin, USA
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Re: Scatter Chart

    Great, Thx Ben.

+ 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. Replies: 1
    Last Post: 07-17-2014, 11:04 AM
  2. Replies: 2
    Last Post: 02-13-2014, 06:18 AM
  3. scatter chart and column chart won't align
    By ckmz in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-12-2013, 09:13 AM
  4. [SOLVED] Exclude one data series from scatter chart legend (but not from the chart)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-29-2012, 05:24 PM
  5. Plot 3 sets of data in scatter chart and area chart in one
    By geoffs52 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2009, 04:42 AM
  6. Convert scatter chart to bubble chart
    By JayUSA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2009, 01:49 PM
  7. scatter chart insists on plotting as a line chart
    By Knows too little in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-11-2005, 03:06 PM

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