build a chart in a cell
 

Is there any way you can put a chart in a cell like B3? I am making a
inventory spread sheet to keep track of items for the month, like to have a
chart in b3 so that you can click on it and it'll show total use of the item
of the month. Is there any way of doing this?

build a chart in a cell
 

you can insert a hyperlink which will take you to a chart sheet and have a
hyperlink on the chart sheet to send you back

or you can write a macro to generate a chart when you click on a cell

"Curtis" wrote:

Is there any way you can put a chart in a cell like B3? I am making a
inventory spread sheet to keep track of items for the month, like to have a
chart in b3 so that you can click on it and it'll show total use of the item
of the month. Is there any way of doing this?

build a chart in a cell
 

Hi,

No. You cannot put a chart in a cell.

Challa Prabhu

"Curtis" wrote:

Is there any way you can put a chart in a cell like B3? I am making a
inventory spread sheet to keep track of items for the month, like to have a
chart in b3 so that you can click on it and it'll show total use of the item
of the month. Is there any way of doing this?

build a chart in a cell
 

You just want a total? You could put a formula in the cell that shows the
total:

=SUM(B4:B200)

If you still want to show something graphically, you could either make a
tiny Excel chart, but you probably won't like the result, you could use one
of the commercial sparkline chart generators (Google Bissantz and
BonaVista), or you could revert to an age-old technique for charting a value
in a cell using a string of characters:

http://peltiertech.com/Excel/Charts/...ulaCharts.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Curtis" wrote in message
...
Is there any way you can put a chart in a cell like B3? I am making a
inventory spread sheet to keep track of items for the month, like to have
a
chart in b3 so that you can click on it and it'll show total use of the
item
of the month. Is there any way of doing this?