Dates not displaying on dashboard chart

Weston Souza

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.

Genevieve P.

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

Genevieve P.

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

Weston Souza

That worked! Thank you.

Genevieve P.

Great, thanks for letting me know!