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?
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?
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?
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?
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?
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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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?
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>
XY Chartlabeler from www.appspro.com and Chart Tools from www.j-walk.com
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <[email protected]>,
[email protected] says...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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?
> >
> >
> >
>
Reread my post. I said that Kelly mentioned addins.
- 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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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?
>>
>>
>>
Could you try to convince your boss, or the IT police, that certain
utilities like this can greatly improve your productivity?
- 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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?
>>
>>
>>
It's probably possible, especially since I used to work on the IT team that
controls our systems but since I found that macro, it's probably not worth my
time to ask for new software.
Thank you to everyone that took the time to help out. You guys are great!
-Scott
"Jon Peltier" wrote:
> Could you try to convince your boss, or the IT police, that certain
> utilities like this can greatly improve your productivity?
>
> - 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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?
> >>
> >>
> >>
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks