?
Solved

Scatter Plot

Posted on 2013-01-10
3
Medium Priority
?
411 Views
Last Modified: 2013-01-14
Hi all,   I am trying to do a scatter plot that shows  the x axis as percent requested and the y axis showing the percent paid.  The data has a column of store numbers and then column for paid and request percentage and I have attached an example. The problem is that it is using the store number as the x axis.  I really want to see where the store falls between the two axis.  

Thanks
Montrof
Example.xlsx
0
Comment
Question by:montrof
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 38766368
Hello,

Although you can easily create a chart like the one you describe, I wonder what value it will be to the reader.

Here's how to create it (one way of many):

- click an empty cell well outside of your data table and click Insert > Scatter chart. This will give you an empty chart.
- On the Chart Tools > Design ribbon click "Select Data" and then "Add"
- Give the series a name and select the data for the X and the Y values

The chart will now show the data points, but there is no indication whatsoever about which store belongs to which data point. Therefore I wonder what value this chart will have to the reader.

See attached file.

cheers, teylyn
27991526.xlsx
0
 
LVL 1

Author Comment

by:montrof
ID: 38766669
The idea would be to see if the number of people asking for assistance are actually paying.  The real data has about 5000 stores so it is hard to select a good way to present it.  I am open to any suggestions on a better way to present the data.  

Thanks,
Montrof
0
 
LVL 50
ID: 38770769
I guess with 5000 data points, this chart will give you an rough indication. If that's all you need, then that's fine.

For a more detailed analysis, you could use the Analysis Toolpak (you need to activate that via File > Options > Add-ins > Manage Excel Add-ins > tick Analysis ToolPak)

Then you could, for example, create a histogram or a pareto chart.

cheers, teylyn
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question