I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 64 towards the top of my home page.

I think that it gives you what you want.

If you agree please hit Yes.

Thanks.


"JLewis" wrote:

I am trying to plot annual sales (horizontal axis) with item price (vertical
axis) and show different markers for customer category (legend). I was able
to do this in Excel 2003 by having each category as a separate column. My
columns are Name, Sales, Cat1, Cat2, Cat3, Cat4. The data in the category
columns for each row would show the item price only in the appropriate column
for that customer's category. The chart range uses only the sales and
category columns. I used a scatter plot chart. In Excel 2003, it worked
great! In Excel 2007, I can't get it to work at all. It will only chart the
last column and the last row of my data. How can I get this to work?