software

I am trying to create a chart that will show over time how my investment
portfolio changes from Small Value companies to (lower left corner) to Large
Value (Upper left corner) to Large Growth (Upper right) and finally to Small
Growth companies (lower right).

I have data for my portfolio along with data that represents each of the
quadrants. Does anyone have any ideas?

Thank you

Tony -

You can set up quadrants as in this example:

peltiertech.com/Excel/Charts/...ackground.html

then plot the appropriate data points.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Tonyquot; gt; wrote in message
...
gt;I am trying to create a chart that will show over time how my investment
gt; portfolio changes from Small Value companies to (lower left corner) to
gt; Large
gt; Value (Upper left corner) to Large Growth (Upper right) and finally to
gt; Small
gt; Growth companies (lower right).
gt;
gt; I have data for my portfolio along with data that represents each of the
gt; quadrants. Does anyone have any ideas?
gt;
gt; Thank you
Is there a way for the data points to get quot;largerquot; as the data becomes
newer? The more recent the portfolio the the larger the data point, the
previous portfolio the smaller the data point?

Thanks for the help.

-Tony

quot;Jon Peltierquot; wrote:

gt; Tony -
gt;
gt; You can set up quadrants as in this example:
gt;
gt; peltiertech.com/Excel/Charts/...ackground.html
gt;
gt; then plot the appropriate data points.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt; quot;Tonyquot; gt; wrote in message
gt; ...
gt; gt;I am trying to create a chart that will show over time how my investment
gt; gt; portfolio changes from Small Value companies to (lower left corner) to
gt; gt; Large
gt; gt; Value (Upper left corner) to Large Growth (Upper right) and finally to
gt; gt; Small
gt; gt; Growth companies (lower right).
gt; gt;
gt; gt; I have data for my portfolio along with data that represents each of the
gt; gt; quadrants. Does anyone have any ideas?
gt; gt;
gt; gt; Thank you
gt;
gt;
gt;

On Thu, 29 Dec 2005, in microsoft.public.excel.charting,
Tony gt; said:

gt;Is there a way for the data points to get quot;largerquot; as the data becomes
gt;newer? The more recent the portfolio the the larger the data point, the
gt;previous portfolio the smaller the data point?

Bubble chart? You can even assign little graphics to the data points
instead of bubbles, and the graphics will change size as the bubbles
would.

--
Del Cotter
NB Personal replies to this post will
send email to
Please send your email to del2 instead

Unfortunately, bubble charts cannot be combined with other chart types to
get different color backgrounds.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Del Cotterquot; gt; wrote in message
...
gt; On Thu, 29 Dec 2005, in microsoft.public.excel.charting,
gt; Tony gt; said:
gt;
gt;gt;Is there a way for the data points to get quot;largerquot; as the data becomes
gt;gt;newer? The more recent the portfolio the the larger the data point, the
gt;gt;previous portfolio the smaller the data point?
gt;
gt; Bubble chart? You can even assign little graphics to the data points
gt; instead of bubbles, and the graphics will change size as the bubbles
gt; would.
gt;
gt; --
gt; Del Cotter
gt; NB Personal replies to this post will
gt; send email to
gt; Please send your email to del2 instead