Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to create "magic grid" chart with names in it
Hi.
I want to create a "gartner's magic quadrant" like grphics. I use the scatter plot to draw two variables into a single point, BUT when I want to name the dots I can't use the name instead the value. vulnerabilidad probabilidad impacto Incendio 2 4 inundacion 2 3 robo 3 5 aceso no autorizado 5 4 perdida de integridad 4 5 falla de energia 3 2 Thanks.... Gonzalo |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to create "magic grid" chart with names in it
Hi,
Here are a couple of free addins that allow you to link data labels to cells. Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com Cheers Andy wrote: Hi. I want to create a "gartner's magic quadrant" like grphics. I use the scatter plot to draw two variables into a single point, BUT when I want to name the dots I can't use the name instead the value. vulnerabilidad probabilidad impacto Incendio 2 4 inundacion 2 3 robo 3 5 aceso no autorizado 5 4 perdida de integridad 4 5 falla de energia 3 2 Thanks.... Gonzalo -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to create "magic grid" chart with names in it
thank you very much...
It was exactly what I've wanted. Gonzalo Andy Pope ha escrito: Hi, Here are a couple of free addins that allow you to link data labels to cells. Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com Cheers Andy wrote: Hi. I want to create a "gartner's magic quadrant" like grphics. I use the scatter plot to draw two variables into a single point, BUT when I want to name the dots I can't use the name instead the value. vulnerabilidad probabilidad impacto Incendio 2 4 inundacion 2 3 robo 3 5 aceso no autorizado 5 4 perdida de integridad 4 5 falla de energia 3 2 Thanks.... Gonzalo -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a combination chart and table with different data. | Charts and Charting in Excel | |||
Macro to create a new chart | Charts and Charting in Excel | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Create a combo chart with two of the same chart types | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) |