Solved

Scatter Plot

Posted on 2013-01-10
3
404 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:
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Complete list of Microsoft tech support phone numbers 5 76
Help with excell ... 6 61
highlight duplicate entry 16 27
ms office troubleshooting for users 8 34
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

919 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

12 Experts available now in Live!

Get 1:1 Help Now