If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
scatter charts
I have the following data in excel and want to create a scatter plot. bread....7....24 drinks....9....29 foods....6....23 When I create this data as a scatterplot it plots the first set of data as one dot and the second set of data as another dot, so 6 dots on total. I can get the scatter plot I require by leaving out the first column of data, but this then does not allow me to label the dots. Please see attachment for more details. Any suggestions Thanking you in advance. +-------------------------------------------------------------------+ |Filename: Doc1.doc | |Download: http://www.excelforum.com/attachment.php?postid=4383 | +-------------------------------------------------------------------+ -- elizkathjones ------------------------------------------------------------------------ elizkathjones's Profile: http://www.excelforum.com/member.php...o&userid=31756 View this thread: http://www.excelforum.com/showthread...hreadid=514813 |
#2
|
|||
|
|||
scatter charts
Hi,
one possibility is to plot each product as a separate series. This results in a separate marker for each product and a legend showing each product's name and marker. If that's what you want you can select all three columns then start the chart wizard. Select X-Y Scatter then Next. In Step 2 of 4 click on the Series tab. Use the Remove button to remove both the Penetration and AWOP series then click on the Add button. Set up this new series by clicking on the little button with the red arrow on the right side of the Name: box, then click on the cell with Brioche then back to the little button with the red arrow. Now click on the little button with the red arrow on the right side of the X Values: box, then click on the worksheet cell containing Brioche's penetration value (7.5), then back to that button. Now click on the little button with the red arrow on the right side of the Y Value: box, then click on the worksheet cell with Brioche's AWOP value (2.7), then back to the little button. That does Brioche as a separate series, now do the same for every other product, starting with the Add button to add the next series for Croissants. After you've done all that you might want to reformat the markers, Excel's choices are pretty poor. Ken Johnson |
#3
|
|||
|
|||
scatter charts
I am running Excel 2000, any ideas if it can create it automatically in later version. Thanks -- elizkathjones ------------------------------------------------------------------------ elizkathjones's Profile: http://www.excelforum.com/member.php...o&userid=31756 View this thread: http://www.excelforum.com/showthread...hreadid=514813 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Automatically Create Scatter Plot Charts | Chris Gregory | Charts and Charting | 8 | October 13th, 2006 03:35 AM |
Frequencies in Scatter Charts | paulabrozek | Charts and Charting | 0 | January 11th, 2006 08:31 PM |
Report with Multiple Scatter Charts | Debbie | Setting Up & Running Reports | 1 | December 9th, 2004 04:36 AM |
Scatter Charts | Aurora | Charts and Charting | 6 | May 22nd, 2004 02:42 AM |
Data labels in scatter charts | Joshua | Charts and Charting | 1 | April 17th, 2004 06:55 PM |