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!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives