WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

data labels in 2007

 
Goto page 1, 2
   Home -> Office -> Charting RSS
Next:  change series or line color in excel 2007 vba  
Author Message
John

External


Since: Jun 12, 2006
Posts: 723



(Msg. 1) Posted: Thu Jan 24, 2008 10:43 am
Post subject: data labels in 2007
Archived from groups: microsoft>public>excel>charting (more info?)

In 2003 I used to be able to hover over a data point on a chart and it would
give me the value... in 2007 it seems I am not able to do that... is that
correct? how can I see the data point value on my chart without double
clicking on it... want to just hover over it
Back to top
Login to vote
Jon Peltier

External


Since: Mar 19, 2004
Posts: 2776



(Msg. 2) Posted: Thu Jan 24, 2008 2:29 pm
Post subject: Re: data labels in 2007 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Apparently it doesn't work unless you activate the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John" <John.DeleteThis@discussions.microsoft.com> wrote in message
news:BB7B2633-5061-477B-B5FC-EC6F6B10BEAB@microsoft.com...
> In 2003 I used to be able to hover over a data point on a chart and it
> would
> give me the value... in 2007 it seems I am not able to do that... is that
> correct? how can I see the data point value on my chart without double
> clicking on it... want to just hover over it
Back to top
Login to vote
Andy Pope

External


Since: Feb 27, 2004
Posts: 638



(Msg. 3) Posted: Thu Jan 24, 2008 7:36 pm
Post subject: Re: data labels in 2007 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,

Check the options,
Show chart element names on hover
Show data point values on hover

Office button > Excel Options > Advanced > Display section.

Cheers
Andy

John wrote:
> In 2003 I used to be able to hover over a data point on a chart and it would
> give me the value... in 2007 it seems I am not able to do that... is that
> correct? how can I see the data point value on my chart without double
> clicking on it... want to just hover over it

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Back to top
Login to vote
John

External


Since: Jun 12, 2006
Posts: 723



(Msg. 4) Posted: Thu Jan 24, 2008 7:36 pm
Post subject: Re: data labels in 2007 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I have both those options checked. Strange... I actually have to select the
series and then hover... which I don't want to have to do

"Andy Pope" wrote:

> Hi,
>
> Check the options,
> Show chart element names on hover
> Show data point values on hover
>
> Office button > Excel Options > Advanced > Display section.
>
> Cheers
> Andy
>
> John wrote:
> > In 2003 I used to be able to hover over a data point on a chart and it would
> > give me the value... in 2007 it seems I am not able to do that... is that
> > correct? how can I see the data point value on my chart without double
> > clicking on it... want to just hover over it
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>
Back to top
Login to vote
Andy Pope

External


Since: Feb 27, 2004
Posts: 638



(Msg. 5) Posted: Thu Jan 24, 2008 8:19 pm
Post subject: Re: data labels in 2007 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

The chart needs to be selected, as Jon stated.
But for me the tooltip appears without the actual series being selected.

Cheers
Andy

John wrote:
> I have both those options checked. Strange... I actually have to select the
> series and then hover... which I don't want to have to do
>
> "Andy Pope" wrote:
>
>
>>Hi,
>>
>>Check the options,
>>Show chart element names on hover
>>Show data point values on hover
>>
>>Office button > Excel Options > Advanced > Display section.
>>
>>Cheers
>>Andy
>>
>>John wrote:
>>
>>>In 2003 I used to be able to hover over a data point on a chart and it would
>>>give me the value... in 2007 it seems I am not able to do that... is that
>>>correct? how can I see the data point value on my chart without double
>>>clicking on it... want to just hover over it
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Back to top
Login to vote
John

External


Since: Jun 12, 2006
Posts: 723



(Msg. 6) Posted: Thu Jan 24, 2008 8:19 pm
Post subject: Re: data labels in 2007 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

disapointing... thx. Brings in a number of problems if worksheet is
locked... etc

"Andy Pope" wrote:

> The chart needs to be selected, as Jon stated.
> But for me the tooltip appears without the actual series being selected.
>
> Cheers
> Andy
>
> John wrote:
> > I have both those options checked. Strange... I actually have to select the
> > series and then hover... which I don't want to have to do
> >
> > "Andy Pope" wrote:
> >
> >
> >>Hi,
> >>
> >>Check the options,
> >>Show chart element names on hover
> >>Show data point values on hover
> >>
> >>Office button > Excel Options > Advanced > Display section.
> >>
> >>Cheers
> >>Andy
> >>
> >>John wrote:
> >>
> >>>In 2003 I used to be able to hover over a data point on a chart and it would
> >>>give me the value... in 2007 it seems I am not able to do that... is that
> >>>correct? how can I see the data point value on my chart without double
> >>>clicking on it... want to just hover over it
> >>
> >>--
> >>
> >>Andy Pope, Microsoft MVP - Excel
> >>http://www.andypope.info
> >>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>
Back to top
Login to vote
Jon Peltier

External


Since: Mar 19, 2004
Posts: 2776



(Msg. 7) Posted: Thu Jan 24, 2008 9:41 pm
Post subject: Re: data labels in 2007 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I have found dozens of little stupid things like this that don't work the
way they used to. Not exactly bugs, I guess, but not exactly working right.
I think they were rushed into releasing Excel 12 with a beta-quality
charting system. I'm hoping they have a chance to fix it in Excel 14.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John" <John RemoveThis @discussions.microsoft.com> wrote in message
news:C7531671-EAAE-46CA-A979-2FA7329F6198@microsoft.com...
> disapointing... thx. Brings in a number of problems if worksheet is
> locked... etc
>
> "Andy Pope" wrote:
>
>> The chart needs to be selected, as Jon stated.
>> But for me the tooltip appears without the actual series being selected.
>>
>> Cheers
>> Andy
>>
>> John wrote:
>> > I have both those options checked. Strange... I actually have to
>> > select the
>> > series and then hover... which I don't want to have to do
>> >
>> > "Andy Pope" wrote:
>> >
>> >
>> >>Hi,
>> >>
>> >>Check the options,
>> >>Show chart element names on hover
>> >>Show data point values on hover
>> >>
>> >>Office button > Excel Options > Advanced > Display section.
>> >>
>> >>Cheers
>> >>Andy
>> >>
>> >>John wrote:
>> >>
>> >>>In 2003 I used to be able to hover over a data point on a chart and it
>> >>>would
>> >>>give me the value... in 2007 it seems I am not able to do that... is
>> >>>that
>> >>>correct? how can I see the data point value on my chart without
>> >>>double
>> >>>clicking on it... want to just hover over it
>> >>
>> >>--
>> >>
>> >>Andy Pope, Microsoft MVP - Excel
>> >>http://www.andypope.info
>> >>
>>
>> --
>>
>> Andy Pope, Microsoft MVP - Excel
>> http://www.andypope.info
>>
Back to top
Login to vote
Bob Flanagan

External


Since: Jan 14, 2008
Posts: 86



(Msg. 8) Posted: Sat Jan 26, 2008 8:34 am
Post subject: Re: data labels in 2007 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Jon, could you expand on what you have found? I have a page at my site I am
updating and would like to list some of those problems.

Bob Flanagan

"Jon Peltier" <jonxlmvpNO.DeleteThis@SPAMpeltiertech.com> wrote in message
news:%23sE3YvvXIHA.6044@TK2MSFTNGP05.phx.gbl...
>I have found dozens of little stupid things like this that don't work the
>way they used to. Not exactly bugs, I guess, but not exactly working right.
>I think they were rushed into releasing Excel 12 with a beta-quality
>charting system. I'm hoping they have a chance to fix it in Excel 14.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "John" <John.DeleteThis@discussions.microsoft.com> wrote in message
> news:C7531671-EAAE-46CA-A979-2FA7329F6198@microsoft.com...
>> disapointing... thx. Brings in a number of problems if worksheet is
>> locked... etc
>>
>> "Andy Pope" wrote:
>>
>>> The chart needs to be selected, as Jon stated.
>>> But for me the tooltip appears without the actual series being selected.
>>>
>>> Cheers
>>> Andy
>>>
>>> John wrote:
>>> > I have both those options checked. Strange... I actually have to
>>> > select the
>>> > series and then hover... which I don't want to have to do
>>> >
>>> > "Andy Pope" wrote:
>>> >
>>> >
>>> >>Hi,
>>> >>
>>> >>Check the options,
>>> >>Show chart element names on hover
>>> >>Show data point values on hover
>>> >>
>>> >>Office button > Excel Options > Advanced > Display section.
>>> >>
>>> >>Cheers
>>> >>Andy
>>> >>
>>> >>John wrote:
>>> >>
>>> >>>In 2003 I used to be able to hover over a data point on a chart and
>>> >>>it would
>>> >>>give me the value... in 2007 it seems I am not able to do that... is
>>> >>>that
>>> >>>correct? how can I see the data point value on my chart without
>>> >>>double
>>> >>>clicking on it... want to just hover over it
>>> >>
>>> >>--
>>> >>
>>> >>Andy Pope, Microsoft MVP - Excel
>>> >>http://www.andypope.info
>>> >>
>>>
>>> --
>>>
>>> Andy Pope, Microsoft MVP - Excel
>>> http://www.andypope.info
>>>
>
>
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Charting All times are: Eastern Time (US & Canada) (change)
Goto page 1, 2
Page 1 of 2

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET |
  • IT Support