Charts within a cell

J

j5b9

Can a cell be used a chart ?
And show a simple range as a chart within a cell using a line or bars and
Only using values given?

a cell (bars) a cell (lines)
::::::::::::::::::: :::::::::::::::
: - : : - :
: - : : - - :
: - - - : : - - - :
: - - - - : :- - - :
: - - - - - : : - - :
::::::::::::::::::: :::::::::::::::


using range : ek7 is 4.2
em7 is 5.3
eo7 is 6.5
et7 is 3
ev7 is 5.4
 
G

Gklass

Yes, hold down the Alt key and move the chart border to match the
cell borders.

I've seen where the next version of Excel will have these as a
charting options --both lines and bars.
Tufte calls them sparklines.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top