build a chart in a cell

[Guest]

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?

 

[Guest]

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

 

[Guest]

Hi,

No. You cannot put a chart in a cell.

Challa Prabhu

 

[Jon Peltier]

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/InCellFormulaCharts.html

- Jon