Charting Help

[spg2112]

Hello people,

I have a scatter graph, the y-axis is fixed cost per loan, the x-axis is profit per loan. The points represent a region, Central, East, West. I want the label to be either Central, East or West. When I try changing the data labels, I either get the x value, or the y value, I can't seem to get East, West or Central for the label. Help!

Is there an addin I need to do this or what?

 

[Damon Ostrander]

Hi Steve,

I just emailed you an example that shows how you can read the chart labels from cells on a worksheet. Hopefully you will see how to adapt the method it uses to your problem.