Dates not displaying on dashboard chart
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.
Best Answer
-
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
-
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
-
That worked! Thank you.
-
Great, thanks for letting me know!