XY/ Scatter charts in Excel 2007 - same for all XL versions

Описание: Office365 Updated video-    • XY scatter chart in Excel. Custom labels f...  
00:00 Scatter graph plots points on a chart using XY co-ordinates
00:30 Set up the data for the XY scatter chart
00:50 Create the XY Scatter chart
01:10 Label the horizontal and vertical axis
02:30 Add points to the XY scatter chart
03:15 Add second vertical axis points to a XY Scatter chart (different series, marker and colors)
05:10 Data Labelling in XY Chart for Excel 2007- link label to a cell manually
06:40 Create new series for each item and label them this way (data label is actually the series name)
07:25 Scatter chart not looking correct? Switch rows and columns first

Excel 2007 Charting/ Graphing Full Course
Tips for charts/ graphs:    • Excel 2007 Graph Tips: Quick chart, align ...  
Explaining the Create and Design Chart Ribbon:    • Create and Design Ribbon in Excel 2007 Graphs  
Explaining the Format Ribbon:    • Excel 2007 Graphs Format Ribbon options av...  
Explaining the Layout Ribbon:    • Excel 2007 Graphs Layout Ribbon  
Customise the chart title:    • Customise the chart title in Excel 2007 Gr...  
Customise the chart area to your liking:    • Customise the chart area to your liking in...  
Customise the chart legend or key:    • Customise the chart legend or key in Excel...  
Customise the gridlines and plot area:    • Customise the gridlines and plot area in E...  
All the options to customise the horizontal and vertical axis:    • Excel 2007 Graphs Horizontal and Vertical ...  
Customise a series in a chart:    • Customise series in a chart in Excel 2007 ...  
Customise a single data point:    • Customise a single data point in Excel 200...  
Add a series to a chart:    • Add new series to Excel 2007 graphs- 3 way...  
Create a secondary axis so that you can compare big and small data:    • Create Secondary Axis in Excel 2007 graphs...  
Bar charts:    • Bar chart graphs in Excel 2007- same as in...  
Pie Charts:    • Pie charts in Excel 2007 Graphs- pull out ...  
Area graphs/ charts:    • Area Charts using Excel 2007 (still releva...  
Radar/ Spider charts:    • Radar/ Spider charts in Excel 2007 Graphs-...  
Stock Charts:    • Waterfall chart in Excel 2007 graphs using...  
Scatter/ XY charts:    • XY/ Scatter charts in Excel 2007 - same fo...  
Combine different chart types on one chart:    • Combining charts/ graphs types into 1 char...  
Link a chart label to a cell in Excel:    • Link chart label to cell in Excel 2007- Tr...  
Link a chart to Word/ PowerPoint so that it updates automatically:    • Link Excel chart to Word/ PowerPoint for a...  
Add trendlines in charts:    • Add trendlines in charts in Excel 2007 gra...  
Change the default colours on graphs/ charts:    • Customise the colors that your graphs star...  
Conditional Formatting in Charts:    • Conditional format charts in Excel 2007- l...  
Create your own chart templates for re-use:    • Create your own chart template for re-use ...  

A scatter graph allows you to plot various points on a chart based on the X,Y co-ordinates. So what you'll see here is we have got a couple of branches. We have got the Revenue Growth Percentage, and we have got the Growth Profit Percentage, so on a single graph I want to see when the Revenue Growth is 21% and the GP percent is 12% on the X,Y axis.

Now setting up for the scatter graph is very important -- so you'll see the first column is always the X axis and the subsequent column or columns is the Y axis. You'll see I have given them some names, but is useful just to put on top what information you are looking for. What we can do is we highlight the X and Y axis -- go to Insert -- you'll see under Scatter there are a couple of options. Let's just use the X, Y co-ordinates here -- click it -- what you'll see is it generates this graph. Looking at this graph it just gets a bit confusing about which percentage applies to what, so we are just going to label them. I go to Layout -- go to axes and I am going to say the horizontal title -- title below -- then I know these belong to the Revenue Growth -- and I know the vertical belongs to the GP percentage. Now we can look at what these are telling us -- you can see if you hover over that point - that this the series with the Revenue Growth of 30%, which is represented here, has a GP percentage of 11%. So each of these points identify the Revenue Growth and the GP percentage. Just looking at this graph you can see that these all look reasonable and there is one here where basically the revenue is negative but the GP percentage is even more negative. It is a nice way of expressing some information.

Just a couple of things to be aware of -- I am just going to move this down -- now I am going to increase this to include those two extra cells . If you want to add a new point, you simply have to put in its X co-ordinate and its Y co-ordinate. You don't have to worry about not duplicating -- so, for example, if we have another point we can put in let's say, another 31% here, same number as there -- but for this one the GP percentage is -- let's make it a big number -- 20%. When I push Enter just watch what happens here -- you'll see we get another point here. So you can add points, you mustn't be afraid to duplicate the points that are on the X axis.

Also be aware that you aren't limited to only one column for the Y axis.