Comparing Two Variables on a Chart in Excel 2007:-

The chart types discussed here are unusual: Scatter, radar, bubble, and surface charts are probably the least understood Excel charts. Both scatter and bubble charts show the interplay between two or three different variables. They require a bit of care in setting up the data. A scatter chart can help you to figure out whether there is a correlation between two variables. A bubble chart has the unique ability to provide data about a third dimension. The first section in this chapter covers the mechanics of creating scatter charts.

When you are thinking about creating scatter charts to show a relationship, you might need to consider alternative charts, such as a paired bar chart, a paired chart, or a frequency distribution. Radar charts are rarely seen but are great for providing performance reviews. A radar chart can show, for example, how a person scored on 5 to 10 key indicators as spokes emanating from a central point.

Surface charts actually attempt to show a 3-D surface floating above an x, y grid. It is difficult to find a dataset that looks cool with a surface chart, and after you’ve found an appropriate dataset, it is often difficult to actually make out the valleys that might occur within the dataset.