Hello All,

I need to plot and correlate four sets of data on a single graph - two of which are numerical and the other two are non-numerical. The outcome of one of the numerical data point correlates to the other, while the non-numerical data points are just descriptive of the numerical points.

For instance, for these sets of data:

Mole data: 5, 6, 10, 1, 12

Percent: 50, 20, 25, 10, 80

Container: Green, Blue, Red, Orange, Yellow

From Site: North West, South East, South West, North East and North Central


I'd like to present the data as non-continuous data points (as in X-Y Scatter) rather than continuous/linked data points (as in line graphs)

Can anyone kindly assist and guide me through how to achieve that in Excel 2007?


Ife