Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to build a chart? | Excel Discussion (Misc queries) | |||
Any way to build one stacked bar chart for three groups of data? | Charts and Charting in Excel | |||
HD I build funct @if cell=AorBorC then ...else if cell=DorE then | Excel Worksheet Functions | |||
is it possible to build a chart with clustered stacked columns ? | Charts and Charting in Excel | |||
How to build a chart with 2 values per item? | Charts and Charting in Excel |