图表轴定制

2

答案

  • 拉姆齐扎基
    拉姆齐扎基 ✭✭✭✭✭✭
    编辑10/15/20

    具有缩放图表的能力，使类似的数据处于相同的比例是至关重要的。我的高管们已经不再使用我们的仪表板，因为所传达的数据具有误导性，除非有人真正关注底部的规模。


    image.png


    · 在Facebook上分享 在Twitter上分享
  • 玛克辛罗伯茨
    玛克辛罗伯茨 ✭✭✭✭

    我认为这需要在下次发布的更新中优先考虑，因为似乎有很多人和我一样，现在发现仪表板中的图表由于自动缩放而不能正确描绘数据的故事。

    · 在Facebook上分享 在Twitter上分享
  • 山姆·霍尔登
    山姆·霍尔登 ✭
    编辑02/25/21

    除此之外，我的公司也非常希望看到这种灵活性的变化发生。

    image.png


    · 在Facebook上分享 在Twitter上分享
  • 凯伦Passmore
    凯伦Passmore ✭

    下一个版本中是否会更新这个更改Axis比例的选项?如果没有，我就回到使用Excel，因为Smartsheet不能给我提供我需要的清晰准确的报告图像。

    · 在Facebook上分享 在Twitter上分享
  • 泰德马宏升
    泰德马宏升 ✭

    那么我们有一个确定的日期吗?我的新构建完成了95%，但由于某些原因，我的图表比例变成了120%。所以从5%变成了25%

    · 在Facebook上分享 在Twitter上分享
  • 泰德马宏升
    泰德马宏升 ✭

    另外，它是如何计算比例的?也许我们的答案就在那里。

    · 在Facebook上分享 在Twitter上分享
  • 泰德马宏升
    泰德马宏升 ✭

    乍一看，这个比例似乎与调整页面上窗口的大小有关。嗯。

    · 在Facebook上分享 在Twitter上分享
  • 马特·斯蒂尔
    马特·斯蒂尔 ✭

    Sasan-已经好几年没有更新了。我同意前面所有用户的请求。这些图表并没有完成它们的基本工作，即直观地显示数据和讲述故事。

    · 在Facebook上分享 在Twitter上分享
  • 汤姆·高尔
    汤姆·高尔 ✭
    编辑09/16/21

    我也需要这个功能，似乎有相当多的用户认为这是一个关键功能。它在路线图上吗?

    能够确保正确地解释信息的可视化表示是指示板的关键需求。添加这些类型的控制可能会导致Smartsheet的仪表板使用率显著上升。我真的不喜欢为了仪表板而回到excel，准确地解释视觉数据对仪表板的成功至关重要。

    请考虑添加此功能和其他与轴相关的自定义。

    · 在Facebook上分享 在Twitter上分享
  • 尼克富恩特斯
    尼克富恩特斯 ✭✭✭✭✭
    图headers.png

    仪表盘上浪费了太多空间。我觉得“最高价是图表顶部”按钮至少不会很难执行。有人要求我把堆叠的图表做得更高，以弥补丢失的英寸，但这只会导致更多的空间浪费。来吧，智能表，这个帖子开始于3年前，它仍然没有修复。

    · 在Facebook上分享 在Twitter上分享
  • 布兰登·R。
    布兰登·R。 员工
    编辑02/11/22
    截图22-02-11 135126.png
    截图2012-02-11 135247.png
    截图2022-02-11 135811.png
    截图2012-02-11 140247.png

    披露:我是一名Smartsheet支持代表


    我可能已经找到了解决这个问题的方法，但是您可能需要根据您的具体需求对解决方案进行微调。


    使用测试数据，我能够创建两个列。我在每个条目中都设置了与前一个条目相当接近的值，以确保图形对于范围来说不会太宽。

    我对两列的数据进行了升序排序，如截图所示。从那里，我可以进入仪表板，看到数据是按照我在工作表中的排序方式进行排序的。

    现在，由于有两组数据被排序，这就是为什么它被分开。但是，这也意味着图本身是按升序对数据排序的。


    选择选项的第二个屏幕截图来自一个报告。这也适用于报表，因此您可以对一些值进行微调，但看起来我们可以获得一个近乎完美的排序选项，至少在将值设置为首先按所需的主列排序，然后再按所需的其他列排序方面是这样。

    我建议使用带有图表小部件的报表，因为这将允许您在一个位置使用多个工作表，并从那里创建排序规则。这可能需要一些尝试和错误，但这是我在没有实际排序选项的情况下所能找到的最接近的。

    “疯狂就是一遍又一遍地做同样的事情，却期望得到不同的结果”——阿尔伯特·爱因斯坦

    “聪明人从愚蠢的问题中学到的东西，比傻瓜从明智的回答中学到的东西要多。”——李小龙

    · 在Facebook上分享 在Twitter上分享
  • 马特Siglinger
    马特Siglinger ✭

    只是再加一句评论，希望能有所改善。无法自定义轴的最大值和最小值确实令人沮丧，并给那些“Excel比Smartsheet好”的人提供了更多的能量。

    · 在Facebook上分享 在Twitter上分享
  • SJ卖家
    SJ卖家 ✭✭✭
    I also really need the ability to edit the maximum end of the scale. I'm portraying data on a 0 - 100% scale, and it automatically sets the max value at 120% instead of 100%. This means that no matter what happens, there will be a huge blank space from 100-120%. <\/p>

    When a project reaches 100%, this conveys the visual message that there is still 20% to go, rather then the visual message that the project is done. <\/p>

    Also, it takes up valuable space on the dashboard so I can't fit two widgets side by side, since both are devoting an entire inch to the blank, useless 100-120% range.<\/p>","bodyRaw":"[{\"insert\":\"I also really need the ability to edit the maximum end of the scale. I'm portraying data on a 0 - 100% scale, and it automatically sets the max value at 120% instead of 100%. This means that no matter what happens, there will be a huge blank space from 100-120%. \\nWhen a project reaches 100%, this conveys the visual message that there is still 20% to go, rather then the visual message that the project is done. \\nAlso, it takes up valuable space on the dashboard so I can't fit two widgets side by side, since both are devoting an entire inch to the blank, useless 100-120% range.\\n\"}]","format":"rich","dateInserted":"2020-10-02T21:57:31+00:00","insertUser":{"userID":127130,"name":"Tyler Durfee","url":"https:\/\/community.smartsheet.com\/profile\/Tyler%20Durfee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-11-12T17:40:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/264723#Comment_264723","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/264723#Comment_264723

    像其他人一样，我在这个帖子中添加了另一条评论，以将这个产品差距推到顶部。ob欧宝娱乐app手机下载

    100%堆叠条形图和柱状图非常常见，任何基本软件都应该提供这种功能。

    当图表的比例持续到120%时，读者必须停下来消化数据。这给我们的用户带来了问题@Matt Siglinger正确地指出了这一点——给了那些批评智能表的人氧气。

    · 在Facebook上分享 在Twitter上分享
  • 劳拉·巴特利特
    劳拉·巴特利特 ✭✭✭

    我正在评论，因为我也喜欢这个功能。我们有一个堆叠条形图，其中有多个数字表示平均天数。由于是在本季度的早期，一个网站显示天数为0.05。因为这个数字，纵轴显示-10。

    image.png


    · 在Facebook上分享 在Twitter上分享

类别

Would this work =[Last Reviewed Date]@row + 540<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-21 16:53:40","updateUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/OLZT5TMCDLUA\/nLGJGXEA8PX07.png","dateLastActive":"2023-02-21T16:52:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":101452,"type":"question","name":"Tool bar icons have turned into blocks...?","excerpt":"Hello, About 2 weeks ago, the icons in the tool bar have turned into blocks, see below. Any thoughts on this? None of my other Chrome pages are doing this. Thank you, Chris","categoryID":321,"dateInserted":"2023-02-21T14:54:34+00:00","dateUpdated":null,"dateLastComment":"2023-02-21T15:06:14+00:00","insertUserID":145158,"insertUser":{"userID":145158,"name":"ChrisVal","url":"https:\/\/community.smartsheet.com\/profile\/ChrisVal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-21T14:58:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145158,"lastUser":{"userID":145158,"name":"ChrisVal","url":"https:\/\/community.smartsheet.com\/profile\/ChrisVal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-21T14:58:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3353985048,"url":"https:\/\/community.smartsheet.com\/discussion\/101452\/tool-bar-icons-have-turned-into-blocks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101452\/tool-bar-icons-have-turned-into-blocks","format":"Rich","lastPost":{"discussionID":101452,"commentID":363405,"name":"Re: Tool bar icons have turned into blocks...?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/363405#Comment_363405","dateInserted":"2023-02-21T15:06:14+00:00","insertUserID":145158,"insertUser":{"userID":145158,"name":"ChrisVal","url":"https:\/\/community.smartsheet.com\/profile\/ChrisVal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-21T14:58:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LRTA5BRWF237\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-21T15:12:39+00:00","dateAnswered":"2023-02-21T15:06:14+00:00","acceptedAnswers":[{"commentID":363405,"body":"

Andree,<\/p>

Thank you for your quick reply. I disabled all the extensions and it fixed the icons. I then enabled all the extension one by one (TRello, lastpass, Google etc.) and found the culprit. It's a PDF editor called Formswift that was causing the issue.<\/p>

Chris.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-21 15:12:39","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-02-21T16:57:51+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":101428,"type":"question","name":"Sharing New Template on Dashboard","excerpt":"We have created several templates that live in folders because they have sheet\/report\/dashboard tied to them. I would like to share these templates on a dashboard so someone simply clicks on the template and are asked to save the template folder to a new workspace. I haven't figured out a way to do this. Anyone have any…","categoryID":321,"dateInserted":"2023-02-20T20:34:59+00:00","dateUpdated":"2023-02-21T09:27:02+00:00","dateLastComment":"2023-02-21T16:45:46+00:00","insertUserID":139975,"insertUser":{"userID":139975,"name":"Rebecca_Kolker","url":"https:\/\/community.smartsheet.com\/profile\/Rebecca_Kolker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VJX53AMQ5SF7\/nXWGMG9EE3KE6.png","dateLastActive":"2023-02-21T16:44:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":139975,"lastUser":{"userID":139975,"name":"Rebecca_Kolker","url":"https:\/\/community.smartsheet.com\/profile\/Rebecca_Kolker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VJX53AMQ5SF7\/nXWGMG9EE3KE6.png","dateLastActive":"2023-02-21T16:44:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3353924445,"url":"https:\/\/community.smartsheet.com\/discussion\/101428\/sharing-new-template-on-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101428\/sharing-new-template-on-dashboard","format":"Rich","tagIDs":[215,223,292],"lastPost":{"discussionID":101428,"commentID":363431,"name":"Re: Sharing New Template on Dashboard","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/363431#Comment_363431","dateInserted":"2023-02-21T16:45:46+00:00","insertUserID":139975,"insertUser":{"userID":139975,"name":"Rebecca_Kolker","url":"https:\/\/community.smartsheet.com\/profile\/Rebecca_Kolker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VJX53AMQ5SF7\/nXWGMG9EE3KE6.png","dateLastActive":"2023-02-21T16:44:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-21T16:38:14+00:00","dateAnswered":"2023-02-21T10:24:39+00:00","acceptedAnswers":[{"commentID":363343,"body":"

Hi @Rebecca_Kolker<\/a> <\/p>

I hope you're well and safe!<\/p>

Unfortunately, it's not possible now, but it's an excellent idea!<\/p>

Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-21 16:38:12","updateUser":{"userID":139975,"name":"Rebecca_Kolker","url":"https:\/\/community.smartsheet.com\/profile\/Rebecca_Kolker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VJX53AMQ5SF7\/nXWGMG9EE3KE6.png","dateLastActive":"2023-02-21T16:44:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":223,"urlcode":"Publish","name":"Publish"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">