LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,814
Default XY chart labeller Issue: (Magic quadrant) But with a twist.

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??


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quadrant Chart Nullifier Charts and Charting in Excel 4 June 20th 07 06:01 PM
Quadrant Chart Sample [email protected] Charts and Charting in Excel 2 September 28th 06 02:54 AM
Four Quadrant Bubble Chart in Excel? [email protected] Charts and Charting in Excel 7 September 20th 06 05:49 PM
Running XY chart labeller using a macro's parameters and arguments. Hari Prasadh Charts and Charting in Excel 1 July 12th 05 05:00 PM
Does anyone have a template or spreadsheet with a Quadrant Chart? MovingOn Charts and Charting in Excel 2 March 20th 05 01:25 AM


All times are GMT +1. The time now is 02:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"