1. First we will create in-cell chart using rept() the usual way
REPT() example is shown below:
=rept("|",10)
will print||||||||||
2. Next combine several incell charts to create a column chart
We can combine various incell charts using excel’s concatenate() function or & operator. Better still you can use the concat() UDF. The trick here is we will delimit each chart with an ENTER key code by usingchar(10)
as the delimiter. When used along with “wrap text” cell format this key
code will force cell contents to a newline where the char code 10 is
inserted. 3. Finally rotate the cell contents by 900 to make the charts vertical
Just select the cell contents, hit ALT+1, and set the alignment formats so that the text is vertically aligned in the cell, and turn on wrap text.That is all, you will now have an incell bar chart that is vertical like the one below:
Pretty cool eh?
No comments:
Post a Comment