Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Scatter Plot
Hello! I'm very new to using Excel, and having problems creating a scatter plot. I have tried using the wizard/chart button on excel, but must be doing something wrong as it's not displaying the data correctly. I'm hoping somebody will help me, please. I'm pulling my hair out, as i cannot do it!! Basically, i have been given the following fields of data - Territory 1 2 3 4 5 6 7 8 9 10 Showings 3 1 4 0 2 4 0 3 1 2 Sales 2.6 1.2 3 1 2 3.6 0.5 3.2 1.8 2.5 I have been told to 'Construct a scatter plot of the data'. Could somebody please give a few minutes to try and find out how to do it? I have attached my (feeble!) attempt at it. I'm hoping i have done it correctly. If not, cound somebody please tell me what i have done wrong? I don't think it's imperative to plot the territory. I think 'showings' and 'sales' compare better. But if i can somehow include territory then it would be better. +-------------------------------------------------------------------+ |Filename: Book1.zip | |Download: http://www.excelforum.com/attachment.php?postid=4528 | +-------------------------------------------------------------------+ -- adamuk ------------------------------------------------------------------------ adamuk's Profile: http://www.excelforum.com/member.php...o&userid=32861 View this thread: http://www.excelforum.com/showthread...hreadid=526703 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Scatter Plot
Your data looks straightforward enough. Just to make su for best results,
the data should be in a contiguous range, no blank rows or columns. It's better in columns, but it's okay in rows. For an XY chart, all data should be numerical, which yours seems to be. For chart types other than XY, delete the label in the top left cell, to help Excel determine the categories and series names. If the data is appropriately arranged, select the entire range (including categories and series names) and run the chart wizard. Choose the chart type in step 1, and in step 2 check that the data range was correctly interpreted. If this doesn't work, describe in words what's wrong. Most people will not open a file. Many because of viruses, but me because of the time and effort it takes. Avoid the easy out of clicking the Attach button. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "adamuk" wrote in message ... Hello! I'm very new to using Excel, and having problems creating a scatter plot. I have tried using the wizard/chart button on excel, but must be doing something wrong as it's not displaying the data correctly. I'm hoping somebody will help me, please. I'm pulling my hair out, as i cannot do it!! Basically, i have been given the following fields of data - Territory 1 2 3 4 5 6 7 8 9 10 Showings 3 1 4 0 2 4 0 3 1 2 Sales 2.6 1.2 3 1 2 3.6 0.5 3.2 1.8 2.5 I have been told to 'Construct a scatter plot of the data'. Could somebody please give a few minutes to try and find out how to do it? I have attached my (feeble!) attempt at it. I'm hoping i have done it correctly. If not, cound somebody please tell me what i have done wrong? I don't think it's imperative to plot the territory. I think 'showings' and 'sales' compare better. But if i can somehow include territory then it would be better. +-------------------------------------------------------------------+ |Filename: Book1.zip | |Download: http://www.excelforum.com/attachment.php?postid=4528 | +-------------------------------------------------------------------+ -- adamuk ------------------------------------------------------------------------ adamuk's Profile: http://www.excelforum.com/member.php...o&userid=32861 View this thread: http://www.excelforum.com/showthread...hreadid=526703 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
date in scatter chart excel 2003 | Charts and Charting in Excel | |||
How do I Plot Data Interactively in Excel | Charts and Charting in Excel | |||
Excel Scatter Plot with connected by smooth lines | Charts and Charting in Excel | |||
BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) |