Charting Help

spg2112 · Feb 28th, 2002, 12:48 PM

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 · Feb 28th, 2002, 02:27 PM

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.

Feb 28th, 2002, 02:27 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	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. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 12:48 PM	#1
spg2112 Board Regular Join Date: Feb 2002 Location: Dallas, TX Posts: 312	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?