[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Scatter Plot

Posted on 2013-01-10
3
Medium Priority
?
412 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

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

650 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