Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Bar charts in tables using REPT function
I know SS is working on embedded charts for Sights but an easy workaround would be to have bar charts in a single cell using the Repeat function as in Excel. Β This is really a Text based formula cheat whereby a "|" is repeated by the value in question (i.e. =REPT("|",Ref) Β ). So, if you had a table and you wanted to rank the values of say, sales teams in a protfolio, you would sort ascending/descending by value and the bar chart column would work very well as a graphical representation in a table. Β Consult this URL to see what I mean: Β http://myexcelonline.com/blog/in-cell-bar-charts-with-the-excel-rept-function/
Β
Can we have this basic formula in SS? Β Not having embedded charts is an obvious and big gap in SS but this bar chart cheat will work well and is really easy.
Β
Comments
-
Hello,
Β
We currently don't have a REPT function or charts integration with Sights, but I'll add your vote for these features to our enhancement request list for further consideration.
Β
We appreciate your input!
