Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Quadrant Chart | Charts and Charting in Excel | |||
Quadrant Chart Sample | Charts and Charting in Excel | |||
Four Quadrant Bubble Chart in Excel? | Charts and Charting in Excel | |||
Running XY chart labeller using a macro's parameters and arguments. | Charts and Charting in Excel | |||
Does anyone have a template or spreadsheet with a Quadrant Chart? | Charts and Charting in Excel |