software

I cannot figure out how to get a bubble chart to do what I want. I have two
variables, Impact vs Cost. Each of the two variables is coded as quot;Lowquot;,
quot;Mediumquot;, or quot;Highquot;. The third variable, which would be the size of the
bublles in the bubble chart, is the number of items for each of the nine
cells in the resulting 3 X 3 grid. Here's the source data:

High101
ImpactMedium121
Low411
LowMediumHigh
Cost
I just can't figure out what to put into the data sources panel as the X,
Y, and Sizes variables in order to get a chart with bubbles and the right
labels. I only get numbers on the axis (1, 2, and 3) instead of High,
Medium, Low. I tried something like ={quot;Highquot;, quot;Mediumquot;, quot;Lowquot;} but that
didn't work. Anyone know how to pull this off? Or that it is impossible and
I should stop trying? Thanks in advance.

Use 1, 2, 3 for low, medium, high in columns 1 and 2 for Impact and Cost. In
column 3 put the bubble sizes. This is your plot. You can train the users
that 1-2-3 mean low-medium-high, or you can add custom axis labels using
dummy series:

peltiertech.com/Excel/Charts/ArbitraryAxis.html

You can't add an XY series, but an added bubble series will do fine.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
PeltierTech.com
_______quot;andy62quot; gt; wrote in message
...
gt;I cannot figure out how to get a bubble chart to do what I want. I have
gt;two
gt; variables, Impact vs Cost. Each of the two variables is coded as quot;Lowquot;,
gt; quot;Mediumquot;, or quot;Highquot;. The third variable, which would be the size of the
gt; bublles in the bubble chart, is the number of items for each of the nine
gt; cells in the resulting 3 X 3 grid. Here's the source data:
gt;
gt; High 1 0 1
gt; Impact Medium 1 2 1
gt; Low 4 1 1
gt; Low Medium High
gt; Cost
gt; I just can't figure out what to put into the data sources panel as the X,
gt; Y, and Sizes variables in order to get a chart with bubbles and the right
gt; labels. I only get numbers on the axis (1, 2, and 3) instead of High,
gt; Medium, Low. I tried something like ={quot;Highquot;, quot;Mediumquot;, quot;Lowquot;} but that
gt; didn't work. Anyone know how to pull this off? Or that it is impossible
gt; and
gt; I should stop trying? Thanks in advance.
Thanks, Jon. I had no idea it was so complicated. At least I wasn't just
being dense.

What I did instead was to hide the grid values (1,2,3) and instead make the
axis labels each be two rows, as follows:

Low Med High
Risk

And then lined up the label until it matched up with the major gridlines.
Maybe a bit unstable, but I think it will do.

quot;Jon Peltierquot; wrote:

gt; Use 1, 2, 3 for low, medium, high in columns 1 and 2 for Impact and Cost. In
gt; column 3 put the bubble sizes. This is your plot. You can train the users
gt; that 1-2-3 mean low-medium-high, or you can add custom axis labels using
gt; dummy series:
gt;
gt; peltiertech.com/Excel/Charts/ArbitraryAxis.html
gt;
gt; You can't add an XY series, but an added bubble series will do fine.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Tutorials and Custom Solutions
gt; PeltierTech.com
gt; _______
gt;
gt;
gt; quot;andy62quot; gt; wrote in message
gt; ...
gt; gt;I cannot figure out how to get a bubble chart to do what I want. I have
gt; gt;two
gt; gt; variables, Impact vs Cost. Each of the two variables is coded as quot;Lowquot;,
gt; gt; quot;Mediumquot;, or quot;Highquot;. The third variable, which would be the size of the
gt; gt; bublles in the bubble chart, is the number of items for each of the nine
gt; gt; cells in the resulting 3 X 3 grid. Here's the source data:
gt; gt;
gt; gt; High 1 0 1
gt; gt; Impact Medium 1 2 1
gt; gt; Low 4 1 1
gt; gt; Low Medium High
gt; gt; Cost
gt; gt; I just can't figure out what to put into the data sources panel as the X,
gt; gt; Y, and Sizes variables in order to get a chart with bubbles and the right
gt; gt; labels. I only get numbers on the axis (1, 2, and 3) instead of High,
gt; gt; Medium, Low. I tried something like ={quot;Highquot;, quot;Mediumquot;, quot;Lowquot;} but that
gt; gt; didn't work. Anyone know how to pull this off? Or that it is impossible
gt; gt; and
gt; gt; I should stop trying? Thanks in advance.
gt;
gt;
gt;