Solved

Scatter Plot

Posted on 2013-01-10
3
401 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
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
teylyn earned 500 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

Expert Comment

by:teylyn
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now