Reduce horizontal axis labels in a chart

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?

Tags:

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • 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.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com