If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data point labels in a scatter diagram
My Y axis is from my "Units" column and my X axis is from my "Revenue"
column. How do I get a third column like "Company Name" to appear as the labels for the data points in my scatter diagram? |
#2
|
|||
|
|||
Data point labels in a scatter diagram
Right click your plot area, choose Source Data, on Series tab in the box with
series names highlight the series you want, to the right of it there is an option to choose your cell containing the name, repeat this for both of your series, then right click on the series in your chart, choose Format Series, on Data Labels tab check Series Name check box. Good Luck, Larissa "sdstephens" wrote: My Y axis is from my "Units" column and my X axis is from my "Revenue" column. How do I get a third column like "Company Name" to appear as the labels for the data points in my scatter diagram? |
#3
|
|||
|
|||
Data point labels in a scatter diagram
Thanks, Larissa, but I don't see the Series Name check box. Is that an
option in Excel 2000? I should have mentioned what version I'm using. -Scott "Larissa" wrote: Right click your plot area, choose Source Data, on Series tab in the box with series names highlight the series you want, to the right of it there is an option to choose your cell containing the name, repeat this for both of your series, then right click on the series in your chart, choose Format Series, on Data Labels tab check Series Name check box. Good Luck, Larissa "sdstephens" wrote: My Y axis is from my "Units" column and my X axis is from my "Revenue" column. How do I get a third column like "Company Name" to appear as the labels for the data points in my scatter diagram? |
#4
|
|||
|
|||
Data point labels in a scatter diagram
I am using 2003
But, you can still just right click your series, ask to show either one value or category name, they will appear in text boxes next to your points on the chart, you can actually edit contents in the text boxes any way you want. Try this see if it works in 2000 Larissa "sdstephens" wrote: Thanks, Larissa, but I don't see the Series Name check box. Is that an option in Excel 2000? I should have mentioned what version I'm using. -Scott "Larissa" wrote: Right click your plot area, choose Source Data, on Series tab in the box with series names highlight the series you want, to the right of it there is an option to choose your cell containing the name, repeat this for both of your series, then right click on the series in your chart, choose Format Series, on Data Labels tab check Series Name check box. Good Luck, Larissa "sdstephens" wrote: My Y axis is from my "Units" column and my X axis is from my "Revenue" column. How do I get a third column like "Company Name" to appear as the labels for the data points in my scatter diagram? |
#5
|
|||
|
|||
Data point labels in a scatter diagram
Still doesn't work. I can choose to show either the value or the label,
which shows either my X or Y axis. I don't think Excel 2000 can do it without an add-in or macro. Thanks, Scott "Larissa" wrote: I am using 2003 But, you can still just right click your series, ask to show either one value or category name, they will appear in text boxes next to your points on the chart, you can actually edit contents in the text boxes any way you want. Try this see if it works in 2000 Larissa "sdstephens" wrote: Thanks, Larissa, but I don't see the Series Name check box. Is that an option in Excel 2000? I should have mentioned what version I'm using. -Scott "Larissa" wrote: Right click your plot area, choose Source Data, on Series tab in the box with series names highlight the series you want, to the right of it there is an option to choose your cell containing the name, repeat this for both of your series, then right click on the series in your chart, choose Format Series, on Data Labels tab check Series Name check box. Good Luck, Larissa "sdstephens" wrote: My Y axis is from my "Units" column and my X axis is from my "Revenue" column. How do I get a third column like "Company Name" to appear as the labels for the data points in my scatter diagram? |
#6
|
|||
|
|||
Data point labels in a scatter diagram
If you are using an XY chart, XYChartlabeler is an excellent add-in that
does exactly what you want. http://www.appspro.com/Utilities/ChartLabeler.htm John Walkenbach also has an excellent labeler in his chat tools add-in. "sdstephens" wrote in message ... My Y axis is from my "Units" column and my X axis is from my "Revenue" column. How do I get a third column like "Company Name" to appear as the labels for the data points in my scatter diagram? |
#7
|
|||
|
|||
Data point labels in a scatter diagram
The options Larissa is talking about were introduced in Excel XP (2002).
The add-ins Kelly mentioned work in Excel 97 through 2003 (and they are as good as she claims). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "sdstephens" wrote in message ... Still doesn't work. I can choose to show either the value or the label, which shows either my X or Y axis. I don't think Excel 2000 can do it without an add-in or macro. Thanks, Scott "Larissa" wrote: I am using 2003 But, you can still just right click your series, ask to show either one value or category name, they will appear in text boxes next to your points on the chart, you can actually edit contents in the text boxes any way you want. Try this see if it works in 2000 Larissa "sdstephens" wrote: Thanks, Larissa, but I don't see the Series Name check box. Is that an option in Excel 2000? I should have mentioned what version I'm using. -Scott "Larissa" wrote: Right click your plot area, choose Source Data, on Series tab in the box with series names highlight the series you want, to the right of it there is an option to choose your cell containing the name, repeat this for both of your series, then right click on the series in your chart, choose Format Series, on Data Labels tab check Series Name check box. Good Luck, Larissa "sdstephens" wrote: My Y axis is from my "Units" column and my X axis is from my "Revenue" column. How do I get a third column like "Company Name" to appear as the labels for the data points in my scatter diagram? |
#8
|
|||
|
|||
Data point labels in a scatter diagram
I can't see where Larissa actually mentions an add-in. I did find a post
from back on December with a macro that worked well. Do you know the name of the add-in that does this? Thanks, Jon. "Jon Peltier" wrote: The options Larissa is talking about were introduced in Excel XP (2002). The add-ins Kelly mentioned work in Excel 97 through 2003 (and they are as good as she claims). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "sdstephens" wrote in message ... Still doesn't work. I can choose to show either the value or the label, which shows either my X or Y axis. I don't think Excel 2000 can do it without an add-in or macro. Thanks, Scott "Larissa" wrote: I am using 2003 But, you can still just right click your series, ask to show either one value or category name, they will appear in text boxes next to your points on the chart, you can actually edit contents in the text boxes any way you want. Try this see if it works in 2000 Larissa "sdstephens" wrote: Thanks, Larissa, but I don't see the Series Name check box. Is that an option in Excel 2000? I should have mentioned what version I'm using. -Scott "Larissa" wrote: Right click your plot area, choose Source Data, on Series tab in the box with series names highlight the series you want, to the right of it there is an option to choose your cell containing the name, repeat this for both of your series, then right click on the series in your chart, choose Format Series, on Data Labels tab check Series Name check box. Good Luck, Larissa "sdstephens" wrote: My Y axis is from my "Units" column and my X axis is from my "Revenue" column. How do I get a third column like "Company Name" to appear as the labels for the data points in my scatter diagram? |
#9
|
|||
|
|||
Data point labels in a scatter diagram
Thanks, Kelly. Unforatunately, this is a work computer and locked down so
that we can't install any software. -Scott "Kelly O'Day" wrote: If you are using an XY chart, XYChartlabeler is an excellent add-in that does exactly what you want. http://www.appspro.com/Utilities/ChartLabeler.htm John Walkenbach also has an excellent labeler in his chat tools add-in. "sdstephens" wrote in message ... My Y axis is from my "Units" column and my X axis is from my "Revenue" column. How do I get a third column like "Company Name" to appear as the labels for the data points in my scatter diagram? |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I need more general XY point to point plotting than XY scatter in | spazminator | Charts and Charting | 12 | December 19th, 2005 05:00 PM |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |