Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2007

Tip: Looking for answers? Try searching our database.

XY chart labeller Issue: (Magic quadrant) But with a twist.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 05 Sep 2007 01:56 GMT
Hiya Folks

I have the same problem as has already been discussed on the forum (see
below@ end of my email), but in my case there is an additional twist.

The orginal issue was solved by using Rob Bovey's XY Chart Labeler to add
labels. The free download is at his web site:

        http://www.appspro.com/Utilities/ChartLabeler.htm

But in my case I have lots of XY points (155 to be precise). The problem is
that 155 visible labels make the chart look very messy. Is there anyway to
make the XY labels invisible until you hover over them with a mouse/pointer?

Any help would be greatly appreciated

Steve

Orginal Problem.

I need to create a chart which is a matrix of four 'boxes' (a bit like the
BCG 'Cash cow, star, etc matrix if you know it). But am having real trouble.

What I need is this (and I'm going for the simplest method here - I ignored
the four 'boxes' and just tried to get the data as I want on the chart):

Data source:

Project Name     Value(1-10)     Difficulty(1-10)
Proj1                       5                     8
Proj2                       8                    10
Proj3                       1                     8
Proj4                       3                     2
Proj5                       6                     4

Chart:

Y-Axis: Value
X-Axis: Difficulty
Label next to each point: Project Name

So, with this graph there would only actually be 5 points - 1 for each
project. And each point would have the project name next to it.

I'll make a crude effort at drawing it:

val)
10 |
   |                                                 X proj2
   |                 X proj5
   |                                     X proj1
   |      X proj4
   |
1   |_____________________X proj3__
   1                                                10 (diff)

I had very moderate success with 'bubbles' - but hit a dead end.
Anyone know how I can achieve this??
Jon Peltier - 05 Sep 2007 13:29 GMT
Try Tushar's Hover Chart Label utility:

   http://tushar-mehta.com/excel/software/chart_hover_label/index.html

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

> Hiya Folks
>
[quoted text clipped - 58 lines]
> I had very moderate success with 'bubbles' - but hit a dead end.
> Anyone know how I can achieve this??
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.