I am trying to chart a lot of data point over multiple years but there are way too many labels on the horizontal axis. Is there a way to reduce the number of labels to allow the chart the be understandable?
Yes. I use a "helper" column for this.
I already have my dates entered into the first column to reference in my metrics formulas. I then add another date type column immediately to the right of the original dates column and label is something along the lines of [Chart Labels]. I then use a formula or even manual entry to only pull certain dates into this new column and the new column is the one I use for the chart labels.
Does all of that make sense? I can find and post a screenshot if you think that would help.
That does make sense, but I am getting my data from a report rather than a sheet so I can't add a manual entry column or formula.
If you are pulling from a report then unfortunately there is no way to adjust them. Feel free to Submit a Product Enhancement Request when you are able.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.