How do I create a chart with more than one (1) data set on the X-axis? Example below.

Answers

  • DKazatsky2
    DKazatsky2 ✭✭✭✭✭✭
    edited 09/13/23

    Hi @ADQ65 ,

    You need to setup sheet like the following.

    Then, insert a chart widget on a dashboard and for the source, highlight the range you want. For Chart Type, choose "Column".

    From there you can play with the various settings to get your desired look.

    Hope this helps.

    Dave

  • ADQ65
    ADQ65 ✭✭

    Thank you for the quick response and suggestion, Dave. I was able to do as you indicated, but not show the data fields on the x-axis (only the date, not the B numbers). I need to show the B numbers as well, as they coincide with the dates.

    Thanks.

    -Armando

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would need to include them in your field labels column. We can't have two separate sets of labels for a chart unfortunately.

    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