Dates not displaying on dashboard chart

Options
Weston Souza
Weston Souza ✭✭✭
edited 03/09/21 in Smartsheet Basics

On each of my project sheets I have one or more rows to capture invoicing with the date and value. I have created a summary report looking at all of the sheets.

In my portfolio dashboard, I reference this report to create a column chart. The dates do not display on the x-axis.

The date column is included in the Data Source.

Any help?

Edit: not sure how to make those captures display without clicking on them.

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Weston Souza

    Since you're only including two columns from the Report into the Chart, you'll want to make sure you've enabled the second setting that says "Use first column as series labels". Although the Date column isn't the first one in the Report, it's the first one out of the two you have selected, so this should bring in your dates as the X-Axis label.

    Let me know if this works for you!

    Cheers,

    Genevieve

Answers