Solved

Scatter Plot

Posted on 2013-01-10
3
409 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 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:Ingeborg Hawighorst
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Determine dependencies 3 21
Excel formula that extracts out name of url 6 46
Access 2010 7 46
Compare data between two sheets in Excel 6 33
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

726 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