Scatter Charts - X Values

C

CWS Lanham

I am using an XY scatter chart with data that looks like

Name Priority Date Lic/Ow
Free 12/16/1998 Lic
Warner 1/28/1999 Lic
Buckmon 7/12/2001 Ow
Tucker 12/28/2000 Ow

The Y values are the priority dates and x values would Lic or Own. Each dataset would be referenced in vertical columns. The problem is how to change data labels so that reflect the data in the name column and the data in the Lic/Own column.

Hope you can help.

Thanks.
 
C

CWS Lanham

Thanks but I was able to use the XY Chart Labeler from AppsPro to accomplish this task.

----- CWS Lanham wrote: -----

I am using an XY scatter chart with data that looks like:

Name Priority Date Lic/Own
Free 12/16/1998 Lic.
Warner 1/28/1999 Lic.
Buckmon 7/12/2001 Own
Tucker 12/28/2000 Own

The Y values are the priority dates and x values would Lic or Own. Each dataset would be referenced in vertical columns. The problem is how to change data labels so that reflect the data in the name column and the data in the Lic/Own column.

Hope you can help.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with scatter diagram excel 2007 2
How do I adjust marker spacing in Excel scatter plot? 1
Problem with xy scatter with dates 7
Sort a data without affecting the scatter chart 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
XY Scatter Chart Not Showing X Axis 1
Occasional meter readings chart 0
Scatter Plot Chart with Category 3

Top