![]() |
Charts within a cell
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 |
Charts within a cell
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. : * * * - * * * * * * : *: * * *- * * * * : : * * * - * * * * * * : *: * *- *- * * * *: : * *- *- * * - * * *: *: *- * *- * - * *: : - *- *- * * - * * *: *:- * * *- *- * * : : - *- *- *- *- * * *: *: * * * - - * * *: ::::::::::::::::::: *::::::::::::::: using range : ek7 is 4.2 * * * * * * * em7 is 5.3 * * * * * * * eo7 is 6.5 * * * * * * * et7 is 3 * * * * * * * ev7 is 5.4 |
All times are GMT +1. The time now is 07:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com